startup switches

[Guest]

I am using Excel 2000. I have a spreadsheet i am starting from Access that
loads a spreadsheet that is formatted and contains a query to create a report
with data users can manipulate. I am using a template and I thought that when
I opened it, it would create a "new" spreadsheet; however I get the template.
I do not want users to modify the template. Is there a startup switch or
another method that would allow me to open a new spreadsheet based on an
existing template?

 

[Jim Rech]

I gather you're running Excel from Access via Automation. If so you might
try opening the template this way:

Workbooks.Add Template:="C:\YourTemplate.xls"

--
Jim Rech
Excel MVP
|I am using Excel 2000. I have a spreadsheet i am starting from Access that
| loads a spreadsheet that is formatted and contains a query to create a
report
| with data users can manipulate. I am using a template and I thought that
when
| I opened it, it would create a "new" spreadsheet; however I get the
template.
| I do not want users to modify the template. Is there a startup switch or
| another method that would allow me to open a new spreadsheet based on an
| existing template?