View Single Post
  #1   Report Post  
Vasanth Vasanth is offline
Junior Member
 
Posts: 10
Post Avoiding display msg when saving a .xlsm file to .xlsx

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