I'm taking four tabs in an XLSM file and creating a new XLSX file. The XLSM has many tabs, and I'm creating 10 XLSX files from this one big XLSM file. When I run my macro, I'm getting the below message:
The following features cannot be saved in macro-freeworkbooks:
VB Project
To save a file with these features, click No, and the choosea macro-enabled file type in the File Type list.
To continue saving as a macro-free workbook, click Yes.
Below is my code:
<strike>
</strike>[/FONT]
I just click yes and it creates the file, but I'm wondering how I can get this message to stop appearing. Also, as far as I can tell, my code is saying to save the file as .xlsx. not sure if the fileformat number has anything to do with it. I've used this method of creating files this way before just not sure why I'm getting this message.
Thanks
The following features cannot be saved in macro-freeworkbooks:
VB Project
To save a file with these features, click No, and the choosea macro-enabled file type in the File Type list.
To continue saving as a macro-free workbook, click Yes.
Below is my code:
Rich (BB code):
Rich (BB code):
Rich (BB code):
Rich (BB code):
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Sub SaveCopyAs_Without_MacrosArrayMatrixReport()
Sheets(Array("Matrix", "MarkerData", "StoreDetail", "% of Red UPCs")).Copy
ActiveWorkbook.SaveAs Filename:="S:\Merch Analysis\ALL REPORTS\Monday Reporting\Best Seller Matrix\Archive\Best Seller Matrix" & [J1] & ".xlsx", FileFormat:=51
Application.DisplayAlerts = False
End Sub
</strike>[/FONT]
I just click yes and it creates the file, but I'm wondering how I can get this message to stop appearing. Also, as far as I can tell, my code is saying to save the file as .xlsx. not sure if the fileformat number has anything to do with it. I've used this method of creating files this way before just not sure why I'm getting this message.
Thanks