![]() |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
|
||||
|
||||
|
You could change the code to use late binding to Excel, then the library entry doesn't need to be checked.
Declare the Excel app as an Object and use the numeric values of any Excel specific commands. There is an example of Excel being used this way on my web site at Extract Data from E-Mail. The code there is for Outlook, but the principles for Word are identical.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
#2
|
|||
|
|||
|
Thank you for your quick reply and helpful link @gmayor. Before my response, may I point to a typo in Extract Data from E-Mail A paragraph (fifth one, I believe) begins with a double-"T": "TThe basic process will..."
The article is very slick. And I understand most of it. But I think I've asked the wrong question. I now remember I have many "Quick Parts" that I doubt migrated with the document. So, though "late binding" may take care of the Excel issue, the application will remain unusable. My solution probably requires a better migration strategy. Particularly if my machine ever crashes. |
|
| Tags |
| object library, references, word 2016 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Problem with Word Mail Merge VBA - Outlook Object Library not recognized
|
shawnhet | Word VBA | 2 | 04-15-2015 07:51 AM |
Microsoft Excel 12.0 Object Library reference upload
|
chamdan | Project | 2 | 04-21-2014 06:30 AM |
| object to remain in view | galgool | PowerPoint | 2 | 01-19-2013 02:47 AM |
Excel VBA: How to add a reference to Microsoft Word Object Library?
|
tinfanide | Excel Programming | 7 | 12-12-2011 05:21 AM |
| Problem: object library invalid or contains references to object definitions | aligahk06 | Office | 0 | 08-19-2010 12:29 PM |