Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-26-2013, 11:57 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 Need to open an Excel WorkBook from Word VBA

Hi Guy
I have in the past month created a complex (for me) userform on Word's VBA.
Now that I am all but done I seem to be unable to open an Excel WorkBook
by using the workbooks.add. It gives me an error 424 object required.


I taught that would work like the Word command Documents.add.
Do I need to declare anything?

Do any of you know how I should proceed.

Thanks
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 01:04 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