| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xltm saveas xlsm
I have the following code within an "xltm" file which I want to then save as
"xlsm": Do fName = Application.GetSaveAsFilename(InitialFileName:="ku pa", filefilter:= _ " Excel Macro Enabled Workbook (*.xlsm), *.xlsm,") Loop Until fName < False ActiveWorkbook.SaveAs Filename:=fName I get ERROR on last statement. How can I add "FileFormatValue = 52" to save the file as a "MacroEnabled" thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a .XLTM template file default to save as .XLSM type? | Excel Discussion (Misc queries) | |||
| xlsm SaveAs xls | Excel Programming | |||
| SaveAs - - provide option to Save As .xlsm or .xls | Excel Programming | |||
| SaveAs XLSM question | Excel Programming | |||
| SaveAs xltm programmatically | Excel Programming | |||
Threaded Mode
