Excel-VBA
鎿嶄綔鏂囦欢鏂规硶鎬荤粨
涓�銆佸埄鐢?/p>
Excel
瀵硅薄鏉ュ鐞嗘枃浠?/p>
.
........................................................................................ 4
1
銆佹墦寮�
Excel
鏂囦欢
.
.......................................................................................................... 4
2
銆佹墦寮�鏂囨湰鏂囦欢
............................................................................................................. 4
3
銆佹墦寮�鍏朵粬鏂囦欢
............................................................................................................. 5
4
銆佷繚瀛樻枃浠?/p>
..................................................................................................................... 6
5
銆佸叧闂枃浠?/p>
..................................................................................................................... 6
6
銆佺患鍚堝疄渚?/p>
..................................................................................................................... 7
7
銆佹�荤粨
............................................................................................................................. 8
浜屻�佸埄鐢?/p>
VBA
鏂囦欢澶勭悊璇彞鏉ュ鐞嗘枃浠?/p>
.......................................................................... 8
锛堜竴锛夋枃浠跺鐞?/p>
............................................................................................................... 8
1
銆?/p>
Name
璇彞
.........................................................................................................
8
2
銆?/p>
FileCopy
璇彞
.....................................................................................................
9
3
銆?/p>
Kill
璇彞
.
.............................................................................................................
9
4
銆?/p>
GetAttr
鍑芥暟
.
......................................................................................................
9
5
銆?/p>
SetAttr
璇彞
.....................................................................................................
1
0
6
銆?/p>
FileLen
鍑芥暟
.....................................................................................................
1
0
7
銆?/p>
FileDateTime
鍑芥暟
...........................................................................................
1
0
锛堜簩锛夌洰褰曞鐞?/p>
............................................................................................................. 10
1
銆?/p>
CurDir
鍑芥暟
......................................................................................................
1
0
2
銆?/p>
ChDir
璇彞
.
.......................................................................................................
1
1
3
銆?/p>
ChDrive
璇彞
....................................................................................................
1
1
4
銆?/p>
Dir
鍑芥暟
.
...........................................................................................................
1
1
5
銆?/p>
MkDir
璇彞
.
......................................................................................................
1
3
6
銆?/p>
RmDir
璇彞
.
......................................................................................................
1
3
锛堜笁锛夊鐞嗘枃鏈枃浠?/p>
..................................................................................................... 13
1
銆?/p>
Open
璇彞
.
.......................................................................................................
1
3
2
銆?/p>
Close
璇彞
........................................................................................................
1
4
3
銆?/p>
Reset
璇彞
.
.......................................................................................................
1
4
4
銆?/p>
FreeFile
鍑芥暟
.
...................................................................................................
1
4
5
銆?/p>
EOF
鍑芥暟
..........................................................................................................
1
5
6
銆?/p>
LOF
鍑芥暟
.
..........................................................................................................
1
5
7
銆?/p>
Loc
鍑芥暟
...........................................................................................................
1
5
8
銆?/p>
Input #
璇彞
.....................................................................................................
1
5
9
銆?/p>
Write #
璇彞
.
....................................................................................................
1
6
10
銆?/p>
Line Input #
璇彞
.
...........................................................................................
1
7
11
銆?/p>
Input
鍑芥暟
......................................................................................................
1
7