Hello I am a newbie to vbscript, and I would like to know if there is a way to read information out of an excel file with about 1200 names in them.
The file basically has the LASTNAME, FIRSTNAME one after anther for 1200 rows. Would there be a way to write a script that reads each name, creates a word object for each name, inputs predefined text into the word folder and saves and closes it? I got the word stuff pretty much down, but all I need to do is read these names out of excel.
Im still a newbie to vbscript, but I know a good portion of PERL even though I am forced to do this in vbscript. Please help!
The file basically has the LASTNAME, FIRSTNAME one after anther for 1200 rows. Would there be a way to write a script that reads each name, creates a word object for each name, inputs predefined text into the word folder and saves and closes it? I got the word stuff pretty much down, but all I need to do is read these names out of excel.
Im still a newbie to vbscript, but I know a good portion of PERL even though I am forced to do this in vbscript. Please help!
