Friday, 22 March 2013

Excel VBA Macro Save a Excel Workbook As Macro Enabled

How to Save a Excel Workbook as Macro Enabled

Sub SaveAsMacroEnable()

Workbooks.Add.SaveAs FileName:="D:\MBA\Merge\" & Export2File & ".xlsm ", FileFormat:=52

'FileFormat:=xlOpenXMLWorkbookMacroEnabled
End Sub






  ---------------------------------------------------------------------------------->
<<< Keep on Following My Blog >>>

<<< Excel your Skills in Excel VBA Macros >>>
     ---------------------------------------------------------------------------------->         
 Thanks
 Tamatam

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts