Changing the default opening format of Excel to xlsx or saving a new workbook before copy

[PaulM100]

Hi,

I am using a Citrix server environment in which I have Excel 2010 with the file format upon opening a new workbook as xls. The fact that is a Citrix server environment it won't retain the settings choice, therefore I cannot change the default format manually once.

I am trying to save a sheet from an xlsm to an xlsx, but due to the situation above I get an 1004 error. I tried to open the workbook and save it before copy/pasting the sheet, but the error happens on the marked line. I tried with both ".xlsx" and file format, without them, only with one at a time but same error pops up every time.

Anyone has any idea on how to fix it?
Thank you!

Please Login or Register  to view this content.

[PaulM100]

Figured out by myself, by using the following line which forces the saving method type

Please Login or Register  to view this content.