Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create folder, text file and vbs script from data in excel
Hi,
I have been tasked with creating a folder, a text file and a vba script from an excel spreadsheet and cannot figure out how to do this. I'm very much a novice at writing macros in excel and need a lot of help in doing this. The excel spreadsheet will be set up in such a way that then will be one column filled with entry numbers (eg. 1, 2, 3,..., n) and the second column filled by entry names (eg. GHWYX4-RT5, GHVT3-RT94,... or something to that effect). What I need to do is create individual folders with the name of each of the entries in the second column (eg. GHWYX4-RT5), then fill each folder with a text file with some constant name (eg. mytext, every text file must have the same name) that contains the first entry in the row, followed by the second entry, separated by a "," (eg. 1, GHWYX4-RT5). There also needs to be no quotations in the text file, it must be exactly in the format I stated. In addition to this, I need to create the vbs file that contains a constant script for all of the vbs files, as well as a constant name for all of the vbs files. I've been searching for quite a while and so far have only been able to create folders from the second column in the list, however with my method I don't really see how I would even create the text files or vba in the folders I created, nor do I even really understand how to create text files or vba from excel. Any help would be greatly appreciated! Thanks very much, Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you create file folder labels in excel? | New Users to Excel | |||
SQL script to select another file in same folder | Excel Programming | |||
Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
Selecting the most recent file in a folder by Macro/VBA script | Excel Programming | |||
Create Folder and Text File in folder | Excel Programming |