Thread: [Solved] Need to open an Excel WorkBook from Word VBA
View Single Post
 
Old 10-03-2013, 08:41 AM
Pierre-Hugues Pierre-Hugues is offline Windows 8 Office 2013
Novice
  
Join Date: Jun 2013
Posts: 8
Pierre-Hugues is on a distinguished road
Default
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?
Reply With Quote