![]() |
|
|
|
#1
|
||||
|
||||
|
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 |
|
| 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 |
Excel or Access for DB?
|
John H. Power | Word | 3 | 08-03-2016 11:52 AM |
How to access Excel worksheet data from Word
|
jules43 | Word VBA | 1 | 03-23-2016 02:36 AM |
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 |