Save .xlsm file as .xlsx

I'm sure I'm making this more difficult than it needs to be. I have a code that saves a .xlsm file as a .pdf file. Once it completes that, I'd like it to save the same file as an .xlsx file. I used the same code for converting the file to .pdf and just changed what I thought I needed to also convert it to .xlsx. Instead what it is doing it saving the file as .xlsx.pdf.

You can probably disregard the code that is posted if someone can simply provide code to save an .xlsm file as .xlsx in the current folder.

I appreciate any help in advance.

Please Login or Register  to view this content.

Not sure what is going on.

You have some code it looks like you want to export as XLXS when it should be XLSX.

Also would you not just save the workbook as an .xlsx workbook?

Saving a .xlsm workbook as an .xlsx workbook.

I suppose you should save the .xlsm workbook first, then save as .xlsx workbook. Set display alerts to false so you don't get a warning.

Please Login or Register  to view this content.