02-17-2011, 01:38 AM
did you try using the Workbook object format?
Code:
Set objWorkBook = objExcel.WorkBooks.Open("http://path.xlsx",false,true) 'file, convert, readonly