Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 question involving SaveAs to .XLS | Excel Discussion (Misc queries) | |||
ActiveWorkbook.SaveAs in excel 2007 | Excel Programming | |||
About _Workbook::SaveAs in Excel 2007 | Excel Programming | |||
SaveAs and Excel Automation | Excel Programming |