Writing files in vbscript

LastAccess property. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. How to create text file and write to it in vbscript Ask Question. Asked 6 years, 1 month ago.

Active 6 years, 1 month ago. Viewed 53k times. Echo objFile. Name Next I'm very amateur when it comes to vbscript. Also, as a bonus, how do I include the date modified of each Access file?

Improve this question. Kevin Kevin 1 1 gold badge 4 4 silver badges 23 23 bronze badges. Related or possibly duplicate : stackoverflow. Add a comment. Active Oldest Votes. Improve this answer. Jake Jake 1 1 silver badge 14 14 bronze badges. This script is much better than the primitive Example 1. My idea is to add code, which copes with situations where the folder already exists.

It also employs the objShell to run the Windows Explorer so that you can test that the script works as designed. See also PowerShell Invoke-Item. Note 1: If you do not add error-correcting code, then there is a real danger that running the script again will destroy the original file. FileExists does is to check to see if there is already a file with the name as that referenced by strFile.

Note 2: This script also features code which protects against the folder already existing — FolderExists. Here is an example where I always learn more when things go wrong.

Sometimes I get away with it, but not in this example. The active part is objShell. In this example, it is as if you click on the Start Menu , Run and type Explorer. With file system objects there is a natural progression, create the folder, then the file, then read or write text to that file. This page shows you to creating a file using the CreateTextFile method. Next step let us explore reading or writing data to the file.

Prerequisites This is a script that will create a file equally well on a Windows server or an XP machine. The best approach is to identify the create folder and create file sections, which are discussed on other pages see menu top left. While the final bonus or cosmetic section is not strictly necessary, I like file scripts to open explorer so that I can check what has happened. This is a script that will execute equally well on a Windows server or an XP machine.

Should you get permission errors, I recommend that you logon as administrator. CreateFolder strDirectory WScript. If objFSO. WriteLine strText objTextFile. Shell" objShell.

If you have not done so already, you may wish to check: See here for a refresher on creating a folder See here for a refresher on creating a file. This utility will also guide you through troubleshooting; the dashboard will indicate whether the root cause is a broken link, faulty equipment or resource overload. What I like best is the way NPM suggests solutions to network problems. Its also has the ability to monitor the health of individual VMware virtual machines. If you are interested in troubleshooting, and creating network maps, then I recommend that you try NPM now.

Note 2: As with many file scripts, the first task is to create an object. Note 3: The central point of this script is the OpenTextFile method. What we must also do is control whether to read, write or append as in this case.

Note 4: You may well be asking, what is the point of an example such as this script? Well, try and imagine a WMI script that has interrogated the operating system for disk information.