VB Code to Save file as 97-2003 Worksheet

Hello:

The name of the file would be the same as original.
Basically, after the rearrange of the data is done, then code needs to save the file in Microsoft 97-2003 Workbook with the original file name.

Please let me know if any questions

Thank u

RM

Like this maybe?

Please Login or Register  to view this content.

Check this link for excel file formats: http://www.rondebruin.nl/mac/mac020.htm

The file you attached is already in 97-2003 format. Can't you just use AcrtiveWorkbook.Save? It will keep whatever format the file is already in.

Hello:

By adding the code

ActiveWorkbook.Save
ActiveWorkbook.Close

it gives Run Time erroe '1004
Method Save' of object '_Workbook' failed.

I would appreciate if you could try and let me know.

Once again thank you for your help.

Riz

Something odd is happening. I save your file to disk, then open it using Excel 2013, then try to save it (using the Excel interface, not code) and I get the following error:

'1-22-14_SF0003_TC_RPT.xls' cannot be saved in the current format. To save your changes, click OK, then save it as the latest format.

I have never seen this error and do not know what causes it, but it may be related to why you are getting the error in the code.

What happens when you open this file in Excel 2010 and then immediately try a save?

Hello:

I am using Excel 2013.
But the file "1-22-14_SF0003_TC_RPT.xls" is Microsoft Excel 97-2003 Worksheet file.
I will have quite a few files every day and would need to rearrange the Clockin-out data and save as MS Excel 97-2003 Worksheet file to work further with other applications.
That's why i will be using above code to rearrange but stuck at automatically saving the file in MS Excel 97-2003 worksheet format.
Please help.

Thanks a lot

Riz

The code that djdjdj posted will force a save in the 97-2003 format. Try that.