![]() |
|
#3
|
|||
|
|||
|
Dim oExcel As Excel.Application
Dim oWB As Workbooks Set oExcel = New Excel.Application Set oWB = oExcel.Workbooks.Open("c:\test\Classeur1.xls") however I get an error 13 at first I used variable to provide the path but since it says type mismatch I changed it to a short location. I even changed from .xlsx to .xls just to be safe but it's still not working. Any suggestion? |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
#REF! error when opening a workbook that contain a refference to another workbook
|
tanababa | Excel | 2 | 06-07-2012 03:11 PM |
| Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
Open Word w Excel & fill Word textboxes w info from Excel fields runtime error 4248
|
Joe Patrick | Word VBA | 2 | 01-30-2012 07:23 AM |
| Shared Excel workbook | eguru2 | Excel | 0 | 07-12-2011 12:02 AM |
| Unable to open Excel 97-2003 workbook | J Partridge | Excel | 1 | 11-07-2010 03:26 AM |