Macro That will save XLSM as XLSX

Good afternoon,

I'm looking for a piece of code that will save as XLSM document as a XLSX to a specific location on the network and use the information in Cell B4 as the file name

can anyone help me with this please?

Thank you

DJ

I have this code now, but what do i need to add to the code to save it as XLSX?

Please Login or Register  to view this content.

Can you save it as an xlsx just using excels normal interface? I thought if you tried to save something with macros as .xlsx it gave you an error.. Try using the macro recorder and see what it gives you.

Otherwise:

Please Login or Register  to view this content.

But like I say, I don't think that will work.

I can use the recorder to do most of what i want, but i would like it to pull the information from cell B4 as the file name when saving

Please Login or Register  to view this content.

Do you know how i can reference the cell B4 for the name?

Thank you very much