| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with saving Excel Template opened in macro
Hi... I open an excel template inside a macro and when I go to save, it
overwrites the template instead of creating new file. When I open the template from Windows, it saves as a file. Anyone know why it behaves differently inside the macro? Thanks -kelli |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with saving Excel Template opened in macro
Instead of opening the template with the macro, create a new workbook
and use your template. Workbooks.Add Template:="C:\YourTemplate.xlt" HTH Charles KelliInCali wrote: Hi... I open an excel template inside a macro and when I go to save, it overwrites the template instead of creating new file. When I open the template from Windows, it saves as a file. Anyone know why it behaves differently inside the macro? Thanks -kelli |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with saving Excel Template opened in macro
Works perfectly... even a little faster I think. Thanks!!
-kelli "Die_Another_Day" wrote: Instead of opening the template with the macro, create a new workbook and use your template. Workbooks.Add Template:="C:\YourTemplate.xlt" HTH Charles KelliInCali wrote: Hi... I open an excel template inside a macro and when I go to save, it overwrites the template instead of creating new file. When I open the template from Windows, it saves as a file. Anyone know why it behaves differently inside the macro? Thanks -kelli |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help in saving an excel file opened in IE | Excel Discussion (Misc queries) | |||
| macro saving problem | Excel Worksheet Functions | |||
| Template opened while being populated | Excel Programming | |||
| Problem with quitting Excel opened through automation | Excel Programming | |||
| Template Wizard - "Saving to Database" Problem | Excel Programming | |||
Hybrid Mode
