VBScript Code to Save an Excel File in Excel 97-2003 Format

[HishamSingalaxana]

Hi,

I'm trying to write this Function that will basically create an excel file and save it in 97-2003 format. i.e basically it has to be saved as a *.xls file although I have Excel 2007 on my system.

Sample of My Function

Please Login or Register  to view this content.

This Function results in creating an excel file with only 1 sheet in it, but the file is saved in excel 2007 format where as I need it to be saved as 97-2003 format.

Does anyone know the code to save it as that?

Thanks

[DonkeyOte]

Welcome to the Board, per forum rules please edit your prior post and encase your Function within CODE tags.

http://www.rondebruin.nl/saveas.htm

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Added this time only

[royUK]

I'm guessing that the code saves to the version of Excel installed. This is a VBA forum,not vbScript Forum

[HishamSingalaxana]

Thank you, Roy

Guess I'm in the wrong forum

Noted about the Code tags btw thanks for adding them.

[romperstomper]

If you checked the link DO posted, you would see that you need to use:

Please Login or Register  to view this content.