VB.net 2005 save Excel 2007 file to Excel 2003 file
Posted on 2010-08-26
I have a vb.net 2005 program that cretaes an excel file
The machine I'm running it on has Windows 7 with Office 2007.
The problrem is, i want the Excel file saved as an .xls file, but it saves it as a .xls file
The clients that will use the reulting output file use machines that are running XP w/ Excel 2003.
I know there are compatibility packs, but I don' twant them to have to open it, then 'save as" and
have several copies of the file, etc.
Here's the statesments I'm using to declare the excel file:
Dim wb As Excel.Workbook
Dim ex As New Excel.Application
wb = ex.Workbooks.Add
The reult of this code is OutputFile.xlsx
What i would like to have is OutputFile.xls
Any help would be greatly appreciated.