ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do i start excel and have it use a template automatically? (https://www.excelbanter.com/excel-programming/336836-re-how-do-i-start-excel-have-use-template-automatically.html)

Vasant Nanavati

how do i start excel and have it use a template automatically?
 
Workbooks.Add "c:\mytemplate.xls"

or something like that.

--

Vasant


"Donna" wrote in message
...
I am starting Excel from within Access by having the user click on a
command
button. That works just fine. Now I want to have Excel open to a new
workbook based on a template I created (schedule.xlt). Can anyonw help me
do
this?




Donna

how do i start excel and have it use a template automatically?
 
Thanks Vasant, but I think I only received part of your answer. I don't want
Excel to open this template every time it starts, just when I start it from
within Access.

"Vasant Nanavati" wrote:

Workbooks.Add "c:\mytemplate.xls"

or something like that.

--

Vasant


"Donna" wrote in message
...
I am starting Excel from within Access by having the user click on a
command
button. That works just fine. Now I want to have Excel open to a new
workbook based on a template I created (schedule.xlt). Can anyonw help me
do
this?






All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com