Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-07-2019, 01:57 PM
Guessed's Avatar
Guessed Guessed is offline How to access Excel from Word Windows 10 How to access Excel from Word Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

A Workbook is an object that requires the Microsoft Excel Object Library. Try ticking that one instead. However it will still have a problem because Application.Workbook in this instance is going to be Microsoft Word and it doesn't contain Workbooks.



Do a google search for "VBA GetObject application excel" if you are trying to access open workbooks from Word.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
excel to word



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel or Access hollies Excel 17 07-18-2017 03:21 AM
How to access Excel from Word Excel or Access for DB? John H. Power Word 3 08-03-2016 11:52 AM
How to access Excel from Word How to access Excel worksheet data from Word jules43 Word VBA 1 03-23-2016 02:36 AM
How to access Excel from Word Moving addresses from a letter in word into access or excel docwilll Office 3 02-22-2014 03:40 PM
Excel to Access to Excel for report automation Nicholaspoe Excel Programming 10 10-08-2013 08:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:18 PM.


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