Vbscript examples read file

Remember, that scripting starts at the folder level, therefore, even if you are primarily interested in saving to a file, your script must first get or create the parent folder. Creating the file, covered on this page, is the middle of a series of three FSO examples. The basics are covered in creating folders Page 1 , this page deals with creating files, whilst Page 3 deals with reading and writing text into the file that we which we created with the first two scripts.

Our mission on this page is clear, to create a file. Naturally, we need a folder to hold our file, therefore, our script will test to see if the folder exists, and if not, then our code will create a folder. The idea behind this script is to highlight the code need to create a file. The cost of focussing on one method is that Example 1 works fine the first time you execute the script, but if you run it a second time you get an error. To cure the problem, move on to the second script. Else keep altering the strDirectory.

Here is what I did as a work-around:. I admit this is poor scripting, but my dilemma is keeping it simple and highlighting the learning steps, versus a slick script that is difficult to follow. To tell the whole truth, I fervently believe that you learn more when scripts go wrong — providing you can fix the error quickly. This is a script that will create a file equally well on a Windows server or an XP machine. Should you get permission errors, I recommend that you logon as administrator.

Note 3: Observe that we also employed the sister method CreateFolder. Next Page. Useful Video Courses. More Detail. Previous Page Print Page. Save Close. Drive Drive is an Object.

Drives Drives is a Collection. File File is an Object. Files Files is a Collection. It Provides a list of all files contained within a folder. If you are using excel file to store your test data, read further to know how to read and write Excel file using VBScript.

This object can do any task required to manipulate an excel workbook such as, read a workbook, write a workbook, add a worksheet, read from cells, write in cells, copy and paste cells, find used ranges etc. This page has list of all the functions which help in reading and writing data from excel workbook. Your Email Address. How to read and write Excel file using VBScript. How to read Data from Excel.