Saving .xlsx in a network folder through a .xlsm file

We have an excel (.xls) file with some macros on it. On that excel file there is an option to export the data into a separate excel file and save the same in a network folder. This is working fine in office 2003 but not with 2010.

We have made all the required code changes such as xlsm, xlsx for the files but the file saving part in the network folder is not working. Getting the below is the error message when we try to save the file.

None of the below possible reason is true. Because it is working fine in office 2003, with the same user level access to the network folder.

Microsoft Excel cannot access the file '<File Location>'. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

and happens at the line

Please Login or Register  to view this content.

Any help is highly appreciated.

Thanks
Jambai

JB,

If i do that, then the excel file (.xlsx) will not save in the network folder.

Thanks
Jambai

With the same code, It is working fine with office 2003.

Thank you
Jambai