EXCEL VBA 常量变量

-
定义变量：
dim 变量名 as 类型:模块级或过程级  类似private
public 变量名 as 类型:多个模块使用
static 变量名 as 类型：静态变量，只有关闭工作薄后释放
手工释放变量 set a = nothing
过程级 --> 过程结束时释放
模块级，工程机 --> 工作薄关闭时释放
定义常量：const 常量名 as 类型=常量值
 
类型：

数据类型                 存储空间　　　　数值范围
Byte　　　　　　　1字节　　　　　　0 - 255
Booleam　　　　　　2字节　　　　　True或者False
Integer　　　　　　2字节　　　　　-32768 - 32767
Long(长整型)　　　　4字节　　　　-2147483648 - 2147483647
Single　　　　　　　4字节　　　　　负值范围:-3.402823E38 - -1.401298E-45
正值范围:1.401298E-45 - 3.402823E38
Double　　　　　　　8字节　　　　负值范围:-1.79769313486232E308 - -494065645841247E-324
正值范围:4.94065645841247E-324 - 1.79769313486232E308
Currency　　　　　　8字节　　　　-922337203685477 - 922337203685477
Decimal　　　　　　14字节　　　　不包括小数时:+/-79228162514264337593543950335
包括小数时:+/7.9228162514264337593543950335
Date　　　　　　　8字节　　　　　1000年1月1日 - 9999年12月31日
Object　　　　　　4字节　　　　　任何引用对象
String(长字符串）　10字节+1字节/字符　　　0 - 约20亿
String(固定长度）　字符串的长度　　　　　　1 - 约65400
Varient（数字）　　16字节　　　　　　　　　Double范围内的任何数值
Varient（文本）　　22字节+1字节/字符　　　　数据范围和变长字符串相同

Comments

Post a Comment

Popular posts from this blog

Nginx Proxy & Load Balance & LNMP

-
Nginx Proxy Service E-commerce website Server 1: provide image request response (  apache / nginx ) Server 2: provide dynamic request response ( php-fpm / apache-php ) Server 3: provide static request response ( apache / nginx ) Server 4: provide data request response ( mysql ) It need one additional nginx server 1. Install nginx 2. proxy to specific server Example location / {      proxy_pass http://192.168.199.187:80/; } location /bbs/ {      proxy_pass http://192.168.199.187:80/bbs/; } location ~* \.(jpg|png|gif)$  {      proxy_pass http://172.16.100.7; } Enhance the log information and specific the hostname location / {      proxy_pass  http://192.168.199.187:80/;      proxy_set_header <parameter name>  $host;  (client requst the hostname )      proxy_set_header <parameter name> $remote_addr; ...
Read more

Snort+barnyard2+Snorby CentOS 6.5_64 Installation

-
#download packages: daq-2.0.2.tar.gz ImageMagicK-6.8.9-8.tar.gz oinkmaster-2.0.tar.gz ruby-1.9.3-p547.tar.gz snort-2.9.6.2.tar.gz snortrules-snapshot-2962.tar.gz MySQL-server-5.5.40-1.rhel5.x86_64.rpm MySQL-client-5.6.21-1.rhel5.x86_64.rpm MySQL-devel-5.6.21-1.rhel5.x86_64.rpm MySQL-shared-5.6.21-1.rhel5.x86_64.rpm epel-release-6-8.noarch.rpm barnyard2-2.1.13.tar.gz #install yum package rpm -ivh epel-release-6-8.noarch.rpm yum install gcc-c++ patch readline readline-devel zlib zlib-devel flex git yum install libyaml-devel libffi-devel openssl-devel make  yum install bzip2 autoconf automake libtool bison iconv-devel libxml2-devel libxslt  yum install gcc g++ build-essential libssl-devel libreadline5-devel zlib1g-devel linux-headers-generic libsqlite3-devel libxslt-devel curl-devel sqlite-devel yum --enablerepo=epel install jasper jasper-libs jasper-devel #Mysql install yum remove mysql mysql-libs rpm -ivh MySQL-server-5.5.40-1.rh...
Read more

ORACLE Error

-
Image
oracle official error explanation  http://docs.oracle.com/cd/E11882_01/server.112/e17766/toc.htm 从服务器下载ALERT日志文件，传输方式需要选择"ASCII" ORA-01078: failure in processing system parameters 发生场景：新建数据库第一次启动时 SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora’ 原因：oracle_sid没有配置正确 解决方案： 1. 修改oracle用户.bash_profile文件中ORACLE_SID后的内容； 2. 重新已oracle用户登录； ORA-01157: cannot identify/lock data file string - see DBWR trace file  Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified. Action: Have operating system make file ...
Read more