Saving Workbook as xlsx

[D_N_L]

Hi all,

I have the following code but it's errors (1004), stating an invalid extension. I'm trying to save the Active Workbook in a different location as a XLSX file. Any ideas?

Please Login or Register  to view this content.

[JieJenn]

Change your code to

Please Login or Register  to view this content.

[D_N_L]

great, thanks!