Use ExcelApp.Workbooks.Item(1).SaveAs (path) and specify version

B

BerniePerks

I'm opening an instance of Excel within Access:
Dim ExcelApp As Object

Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Workbooks.Add

Then writing stuff to it and I want to save as acSpeadsheetTypeExcel8
(though I have Excel 2007 installed)

Can I do this using

ExcelApp.Workbooks.Item(1).SaveAs (path)?
 
Top