Guidance on automating the creation of Excel files from Excel
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 |
Guidance on automating the creation of Excel files from Excel
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 |
All times are GMT +1. The time now is 05:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com