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