SaveAs alert when change xlsm to xlsx

[Altair]

Hi all.

So I am very new to VBA/Macros most of my programming experience is in scripting languages like python. I have looked at previous post but nothings seems to solve my problem.

I am currently setting up an excel sheet that contains a fair amount of macros as to guide end-users when the sheet is filled in. Finally I want the sheet to be saved as a normal xlsx by the click of a bottom on the sheet.

I have a macros button that points to this :

Please Login or Register  to view this content.

This works but it still results in an alert that when saving as xlsx that macros will be removed. I was under the impression that Application.DisplayAlerts = False would disable the alerts and the SaveAs would just "happen"

Help would be appreciated

[mrice]

You might be better creating a new workbook and copying the sheets from your macro workbook across to this and saving the new workbook as the XLSX.

[Debraj Roy]

One more thing..

FileFormat:=52

is used to Open XML Workbook Macro Enabled
You may try FileFormat:=-4143

[ankitparate]

Hi Altair,

Use this code, I hope it might help you

Sub SaveAsAndClose()

ActiveWorkbook.SaveAs "finaloutput.xlsx"
ActiveWorkbook.Close

End Sub

[Altair]

Thanks for the replies.

Mrice I have tried your suggestions with copy the sheet to new workbook but its seems to be copying the macros with? Any suggestions on how I can copy the entire sheet without the macros? I might mentioned that the sheet contains formatting (colors etc. I will like to have copy as well)

Thanks

[Altair]

This is what I did in the end and it worked for me....

Please Login or Register  to view this content.