vba script to generate files based on an data from an Excel sheet

**bananas** · 10-29-2007, 06:36 PM

Hi guys,

I've got an Excel sheet with approximately 2,000 file names (all csv files) stored in the first column. I will call this sheet files.xls. I want to create a macro which does the following:
Step 1. Open a file called template.xls. This sheet contains all the formatting and some VBA code.
Step 2. In template.xls ... import the first file (e.g. a.csv) mentioned in the list of files listed in the first column in files.xls.
Step 3. Save template.xls with the imported data from a.csv as a new file called a.xls.
Repeat this for all the files in files.xls

Can someone help me write this vba script ? I'm a complete newbie in vba but I really need this script to save lots of time.

Thanks,
Bananas

**bananas** · 10-30-2007, 03:52 AM

some feedback please ?

**bananas** · 10-30-2007, 11:56 AM

Is there someone who can give me at least a hint ... how can I start with the script ?

**shg** · 10-30-2007, 12:39 PM

Add this code to a workbook in the directory where the csv files are located.

Please Login or Register  to view this content.

**bananas** · 10-30-2007, 02:34 PM

Hi Shg,

Thank you very much for the script. Is it possible to adapt the script and let it work with an 'import data' instead of a copy/paste of the data ?

Thanks again, you are going to save me lots of time

Bananas