Guidance on automating the creation of Excel files from Excel

  • Thread starter Thread starter LetMeDoIt
  • Start date Start date
L

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
 
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
Click to expand...

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
 
Back
Top