Guidance on automating the creation of Excel files from Excel

[LetMeDoIt]

Help....

I need help or some example on how to generate Excel files based on
one main Excel file. The main Excel file once executed (manually)
will read a text file and grab each consecutive records and generate
another excel file with the name taken from the record read in the
text file...

Any help is greatly appreciated...

regards, Chris

 

[Asko Telinen]

LetMeDoIt kirjoitti:

Help....

I need help or some example on how to generate Excel files based on
one main Excel file. The main Excel file once executed (manually)
will read a text file and grab each consecutive records and generate
another excel file with the name taken from the record read in the
text file...

Any help is greatly appreciated...

regards, Chris

Use Workbooks.Add method which creates new workbook with default name
after that you can save or rename it. Or Workbooks.OpenWorkBook, which
opens excel file from disk.

Asko