Save Excel File as 2003 Programmatically

[Sarah]

I have a database I created in Microsoft Access 2003 and I was just updated
to Office 2007 with Microsoft Access 2007. I have code that creates an excel
file and writes to it. Now that I have upgraded to 2007 the Excel file that
is created is no longer a 2003 Excel file. A 2007 Excel file is always
created. I use the following code to get started:

Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add

How do I save the excel file as a 2003 excel file. I've tried using the xls
extension, but the file is acutally a 2007 excel file. Any suggestions on
how to save my excel workbook with file type 2003?

Thank you.

Sarah

 

[RoyVidar]

I have a database I created in Microsoft Access 2003 and I was just
updated to Office 2007 with Microsoft Access 2007. I have code that
creates an excel file and writes to it. Now that I have upgraded to
2007 the Excel file that is created is no longer a 2003 Excel file.
A 2007 Excel file is always created. I use the following code to
get started:

Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add

How do I save the excel file as a 2003 excel file. I've tried using
the xls extension, but the file is acutally a 2007 excel file. Any
suggestions on how to save my excel workbook with file type 2003?

Thank you.

Sarah

Check out this information:
http://www.rondebruin.nl/saveas.htm

 

[Sarah]

Thank you! That worked great!

Check out this information:
http://www.rondebruin.nl/saveas.htm