Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi
I am running a macro from xlsxm file and in the end i am savng the workbook as xlsx fomat . But i get the display message as ------------------------------------------------------------------ The following feature cannot be saved in macro-free workbooks .VB Project To continue saving as macro-free workbook click 'YES' ------------------------------------------------------------------ I click manually yes each time the macro is run. Is there any way to suppress the display message and save it as xlsx file. Below is the code ChDir "C:\My documents" ActiveWorkbook.SaveAs Filename:= _ "C:\My documents\User report.xlsx", _ FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False Please help me in this issue |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing .xlsm, .xlsx with OLEDB | Excel Programming | |||
FYI Excel 2007: Saving a xlsm file with a hidden worksheet activated makes worksheet visible | Excel Programming | |||
problem saving xlsx file | Excel Discussion (Misc queries) | |||
Password security problem: view of the hiden worksheet in xlsm and xlsx file !? | Excel Programming | |||
saving xlsx file as xls changes currency symbols | Setting up and Configuration of Excel |