Programatically save EXCEL file to earlier version...

[VisualGuy]

I would like to be able to control what version an EXCEL file is saved in. I run EXCEL 2007 on my workstation. So whenever I create a new excel file, even if I reference an earlier version of Interop.Excel, people who are running an earlier version of excel cannot open my files. Can't this be controlled?

wbNew.SaveAs("MyFile.xls")

 

[PRPhx]

Hmmm. Don't know if this will work for you. Found a reference to a program called tlbImp.exe, which converts a typed lib (.olb) file to a .dll file. You might want to look here:

http://www.vbdotnetheaven.com/Uploa...adsheet04182005093012AM/ExcelSpreadsheet.aspx

 

[Sorwen]

Example: In Excel 2007 save as 2003 Workbook.

wbNew.SaveAs("MyFile.xls", 56)

Best advice I can give for working in Excel is if your not sure what to do then record a macro of what you need to do in Excel and then look at the VBA code for it. Something like this would show 56 as xlExcel8. You could then go here:

http://msdn.microsoft.com/en-us/library/bb149081.aspx

to find out what that means.

-I hate Microsoft!
-Forever and always forward.
-My kingdom for a edit button!