03-02-2012, 10:21 AM
after the above you should open workbook by below like code and remaining to read cells. (googe it)
Code:
Set oWorkbook = oExcel.Workbooks.Open(excelfilepath)