VBA学习日志- for excel

oct.09  ==

 

MID(text,start_num,num_chars)     返回文本字符串中从指定位置开始的特定数目的字符，该数目由用户指定。MIDB用于双字节字符

示例： =MID("Graduation",3,5)  等于 "adu"

 

MsgBox "text" 弹出对话框“text”

 

读取文档

Dim wkbk As Workbook, shtSetup As Worksheet

Set shtSetup = wkbk.Worksheets("Setup")

filenm = shtSetup.Range("C3")

Open filenm For Input As #1

...

Close #1

 

 

Debug.Print "..." ?

Do While Not EOF(1)  ?

===