I wrote some VB to open up and specific Excel spreadsheet in office 2003. The code i used to do this was:
Set oExcel = CreateObject("Excel.Application")
Set oWB = oExcel.Workbooks.Open(SheetLocation)
This worked fine.
We have now moved to office 2010 and the above no longer works. I have added the Excel 14.0 object library reference but the error message i get is:
"Unable to get the Open Property of the workbook class"
It errors on "Set oWB = oExcel.Workbooks.Open(Shee
Any ideas how to open up the spreadsheet in the correct way for 2010?