内容发布更新时间 : 2024/5/3 21:48:48星期一 下面是文章的全部内容请认真阅读。

Excel-VBA操作文件方法总结

一、利用Excel对象来处理文件 ......................................................................................... 4 1、打开Excel文件 ........................................................................................................... 4 2、打开文本文件 ............................................................................................................. 4 3、打开其他文件 ............................................................................................................. 5 4、保存文件 ..................................................................................................................... 6 5、关闭文件 ..................................................................................................................... 6 6、综合实例 ..................................................................................................................... 7 7、总结 ............................................................................................................................. 8 二、利用VBA文件处理语句来处理文件 .......................................................................... 8 （一）文件处理 ............................................................................................................... 8

1、Name 语句 ......................................................................................................... 8 2、FileCopy 语句 ..................................................................................................... 9 3、Kill 语句 .............................................................................................................. 9 4、GetAttr 函数 ....................................................................................................... 9 5、SetAttr 语句 ..................................................................................................... 10 6、FileLen 函数 ..................................................................................................... 10 7、FileDateTime 函数 ........................................................................................... 10

（二）目录处理 ............................................................................................................. 10

1、CurDir 函数 ...................................................................................................... 10 2、ChDir 语句 ........................................................................................................ 11 3、ChDrive 语句 .................................................................................................... 11 4、Dir 函数 ............................................................................................................ 11 5、MkDir 语句 ....................................................................................................... 13 6、RmDir 语句 ....................................................................................................... 13

（三）处理文本文件 ..................................................................................................... 13

1、Open 语句 ........................................................................................................ 13 2、Close 语句 ........................................................................................................ 14 3、Reset 语句 ........................................................................................................ 14 4、FreeFile 函数 .................................................................................................... 14 5、EOF 函数 .......................................................................................................... 15 6、LOF 函数 ........................................................................................................... 15 7、Loc 函数 ........................................................................................................... 15 8、Input # 语句 ..................................................................................................... 15 9、Write # 语句 ..................................................................................................... 16 10、Line Input # 语句 ............................................................................................ 17 11、Input 函数 ...................................................................................................... 17

12、Print # 语句 .................................................................................................... 18 13、Width # 语句 .................................................................................................. 19

（四）处理二进制文件 ................................................................................................. 19

1、Put 语句 ........................................................................................................... 19 2、Get 语句 ........................................................................................................... 20 3、Seek 语句 ......................................................................................................... 20 4、Seek 函数 ......................................................................................................... 21

（五）总结 ..................................................................................................................... 21 三、利用FileSystemObject对象来处理文件 ................................................................... 21 （一）准备工作 ............................................................................................................. 22 （二）FileSystemObject对象的方法 ............................................................................ 22

1、GetDrive 方法 .................................................................................................. 22 2、GetDriveName 方法 ......................................................................................... 23 3、GetExtensionName 方法 ................................................................................. 23 4、GetBaseName 方法 .......................................................................................... 23 5、GetAbsolutePathName 方法 ............................................................................ 23 6、GetFile 方法 ..................................................................................................... 24 7、GetFileName 方法 ............................................................................................ 24 8、GetFolder 方法 ................................................................................................. 24 9、GetSpecialFolder 方法 ..................................................................................... 24 10、GetParentFolderName 方法 .......................................................................... 25 11、GetTempName 方法 ...................................................................................... 25 12、BuildPath 方法 ............................................................................................... 25 13、CreateFolder 方法 .......................................................................................... 25 14、CopyFolder 方法 ............................................................................................ 25 15、MoveFolder 方法 ........................................................................................... 26 16、DeleteFolder 方法 .......................................................................................... 27 17、FolderExists 方法 ........................................................................................... 27 18、DriveExists 方法 ............................................................................................. 27 19、FileExists 方法 ................................................................................................ 27 20、CreateTextFile 方法 ........................................................................................ 27 21、OpenTextFile 方法 .......................................................................................... 28 22、CopyFile 方法 ................................................................................................. 28 23、MoveFile 方法 ................................................................................................ 28 24、DeleteFile 方法 .............................................................................................. 29

（三）处理驱动器 ......................................................................................................... 29 （四）处理文件夹 ......................................................................................................... 30

1、获取文件夹的信息 ........................................................................................... 30 2、Folder对象的方法 ........................................................................................... 30 ⑶Delete 方法 ........................................................................................................ 31 ⑷CreateTextFile 方法 ............................................................................................ 31

2 / 48

（五）处理文件 ............................................................................................................. 31

1、获取文件的信息 ............................................................................................... 31 2、File对象的方法 ................................................................................................ 31

（六）处理文本文件 ..................................................................................................... 32

1、打开或创建文本文件 ....................................................................................... 32 2、读取文件 ........................................................................................................... 32 3、写入数据到文件 ............................................................................................... 34 4、关闭文件 ........................................................................................................... 34

（七）总结 ..................................................................................................................... 34 四、利用API函数来处理文件 .......................................................................................... 35 （一）处理驱动器及目录 ............................................................................................. 35

1、GetLogicalDrives ................................................................................................ 35 2、GetDriveType ..................................................................................................... 36 3、GetDiskFreeSpaceEx .......................................................................................... 37 4、CreateDirectory, CreateDirectoryEx .................................................................. 38 5、RemoveDirectory ............................................................................................... 39 6、SetCurrentDirectory .......................................................................................... 39 7、GetSystemDirectory .......................................................................................... 39

（二）处理文件 ............................................................................................................. 40

1、CreateFile .......................................................................................................... 42 2、lcreat ................................................................................................................. 43 3、lopen ................................................................................................................. 44 4、GetFileTime ....................................................................................................... 44 5、CopyFile ............................................................................................................. 45 6、MoveFile, MoveFileEx ....................................................................................... 45 7、DeleteFile .......................................................................................................... 46 8、ReadFile ............................................................................................................. 46 9、WriteFile ............................................................................................................ 47 10、SHFileOperation .............................................................................................. 47

（三）总结 ..................................................................................................................... 48

3 / 48