Site icon 时鹏亮的Blog

VBS Excel 宏 VBA 写文件 示例代码

请知悉:本文最近一次更新为 4年 前,文中内容可能已经过时。

VBS Excel 宏 VBA有时需要写出一些内容到文件,如何处理呢?

示例代码如下:

Dim filePath As String
filePath = "C:\temp\MyTestFile.txt"

' The advantage of correctly typing fso as FileSystemObject is to make autocompletion
' (Intellisense) work, which helps you avoid typos and lets you discover other useful
' methods of the FileSystemObject
Dim fso As FileSystemObject
Set fso = New FileSystemObject
Dim fileStream As TextStream

' Here the actual file is created and opened for write access
Set fileStream = fso.CreateTextFile(filePath)

' Write something to the file
fileStream.WriteLine "something"

' Close it, so it is not locked anymore
fileStream.Close

参考资料

How to create and write to a txt file using VBA


如您从本文得到了有价值的信息或帮助,请考虑扫描文末二维码捐赠和鼓励。

尊重他人劳动成果。转载请务必附上原文链接,我将感激不尽。


与《VBS Excel 宏 VBA 写文件 示例代码》相关的博文:

Exit mobile version