05 VBA内部函数.ppt

文档介绍：第五章 VBA内部函数
5. 6 文件操作函数
5. 7 输入输出函数
5. 8 财会类函数
5. 9 格式化数据
5. 10 系统与对象函数
数学函数
5. 2 数组函数
5. 3 字符串操作函数
5. 4 日期和时间函数
5. 5 数据类型检查与
转换函数
(number)
(number)
(number)
(number)
(number)
(number)
(number)
5 .1 数学函数
(number)
[(number)]
(expression
[,numdecimalplaces])
(number)
(number)
(number)
(number)
(number)
返回主菜单
(arglist)
(sourcesrray, match
[,include[, compare]])
(arrayname[, dimension])
(expression[, delimiter[,
limit[, compare]]])
(arrayname[, dimension])
5 . 2 数组函数
返回主菜单
5 . 3 字符串操作函数
([start, ]string1,
string2[, compare])
(stringcheck,
stringmatch[, start[, compare]])
(sourcearray[, delimiter])
(string)
(string, length)
(string | varname)
(string)
(string, start[, length])
(expression, find,
replace[, start[, count[, compare]]])
(string, length)
(number)
(string1,
string2[, compare])
(string,
conversion, LCID)
(
expression)
(string)
(number,
character)
(string)
(string)
返回主菜单
. 4 日期和时间函数

(interval, number, date)
(interval, date1, date2[,
firstdayofweek[, firstweekofyear]])
(interval,date[,firstday-
ofweek[, firstweekofyear]])
(year, month, day)
(date)
(date)
(time)
(time)
(date)
(month[,
abbreviate])

(time)


(hour,
minute, second)
(time)
(date,
[firstdayofweek])
(weekday,
abbreviate, firstdayofweek)
(date)
返回主菜单
(varname)
5 . 5 数据类型检查与
转换函数
(expression)
(expression)
(expression)
(argname)
(expression)
(string)

(index, choice-1[,
choice-2, ...