ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel 2007 saveas (https://www.excelbanter.com/excel-programming/416243-excel-2007-saveas.html)

greg

excel 2007 saveas
 
Hello,
I have excel 2007.
In code, I am opening an xlt file with macros, and then doing a saveas to an
..xlsm file.
I need to have the template an xlt file. because i am sharing with 2003.

Now when I saveas, a dialog pops up asking if I want to save as a non macro
file.

Why is this happening? I am saving as an xlsm file.

the file gets saved as .xlsm.
But it does not seem like macros can run if i open the file as xlt?

So
I am trying to open an xlt file (with macros).
do a saveas to xlsm
then i call a method in that xlsm file.
then i save and close.

any work arounds?




All times are GMT +1. The time now is 12:57 PM.

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