Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLAP Creation in Excel / MS Query -- .cub files | Excel Discussion (Misc queries) | |||
Help with automating creation of Pie Chart(s) | Charts and Charting in Excel | |||
How can I selectively stop creation of Excel *.xlk files? | Setting up and Configuration of Excel | |||
Automating hyperlink creation | Excel Worksheet Functions | |||
Automating production book creation - many procedures to run | Excel Programming |