I am using a script to export the data in Excel,My script works fine in excel 2000,2003.But gives Automation Error in Excel 2007.Could not fine the exact solution and got strucked in mid way.
Dim vtFilename As Variant
Set excelApp = CreateObject(“Excel.Application”)
vtFileName = w.SaveFileDialog(False, “Choose New File”, “Microsoft Excel|*.xls”, “E:”)
excelApp.DisplayAlerts = False
Set excelNewWkbk = excelApp.Workbooks.Add
Subject: Automation Error in Excel
Check that Excel is well installed.
The reference “Excel.application” is hidden somewhere in the Windows Registry, with all that kind of objects.
Check that the registry folder “Excel.application” exists, and not only “Excel.application.number”.
By the past, Excel often had troubles to keep a generic entry, and you had to specify the Excel version in your object.
Perhaps you may find more help in an Excel forum.