UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Workbook extension is xls rather than xlsm    
 
   
idisc
post Mar 5 2009, 06:43 AM
Post #1

UtterAccess Addict
Posts: 224
Having a bit of a problem with VBA code that worked fine under Excel 2003 but is now not working properly. Workbooks were being saved using the following code:

ActiveWorkbook,SaveAs Filename:= _
Copies & CPT & "_Extension_" & Mdate, _
FileFormat:=xlWorkbookNormal, _
CreateBackup:=False

It works OK and is being saved to the right directory, but the file extension is .xls rather than .xlsm

I'm not sure whether FileFormat should read xlWorkbookDefault or something else, to make the extension read .xlsm

Any assistance would be appreciated. Thanks.
Go to the top of the page
 
+
xld
post Mar 6 2009, 10:05 AM
Post #2

UtterAccess Addict
Posts: 184
Use a fileformat of xlOpenXMLWorkbookMacroEnabled
Go to the top of the page
 
+
idisc
post Mar 7 2009, 02:00 PM
Post #3

UtterAccess Addict
Posts: 224
Thanks xld, i will try that.
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 11:03 PM