ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   GetObject Template (https://www.excelbanter.com/excel-programming/374523-getobject-template.html)

ALEX

GetObject Template
 
Using GetObject, how can I indicate an Excel template that I want the file to
use?

Thanks

Alex

Charles Chickering

GetObject Template
 
Alex, I'm not sure what you are trying to do. Can you just use:
Dim wb as Workbook
Set wb = Workbooks.Add("C:\YourPath\YourTemplate.xlt")
--
Charles Chickering

"A good example is twice the value of good advice."


"Alex" wrote:

Using GetObject, how can I indicate an Excel template that I want the file to
use?

Thanks

Alex



All times are GMT +1. The time now is 05:56 PM.

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