Hi,
I already know how to create new worksheets from a template file but
I don't know how to import
my data in an automated way.
When I type "Excel /t TemplateName.xlt" it generates a new empty
worksheet with my predefined graphs ready to go, but there is no data
in the columns to be graphed.
I have programs that generate standard .CSV data with the data I care
about always in the correct columns. When I import the data by hand
it my new worksheet graphs it perfectly, but I don't want to import the
data by hand. I want to tell my command line to apply the template and
also import the data in one step.
All the forums I've read so far don't have any information on this.
Do I need to create a data import macro in my template?
- Sincerely,
nobidon@gmail.com
Gord Dibben - 03 Jan 2007 23:55 GMT
Macros cannot be run from the command line, only from workbooks.
Create a Workbook_Open macro for your Template so when a workbook based on the
Template opens, the data will be imported to that workbook.
Gord Dibben MS Excel MVP
>Hi,
> I already know how to create new worksheets from a template file but
[quoted text clipped - 17 lines]
>
>nobidon@gmail.com