Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-03-2013, 08:41 AM
Pierre-Hugues Pierre-Hugues is offline Need to open an Excel WorkBook from Word VBA Windows 8 Need to open an Excel WorkBook from Word VBA Office 2013
Novice
Need to open an Excel WorkBook from Word VBA
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to open an Excel WorkBook from Word VBA #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
Need to open an Excel WorkBook from Word VBA 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft