Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-28-2022, 08:50 PM
gmayor's Avatar
gmayor gmayor is offline cannot get microsoft Excel 16.0 object library to remain checked when copying word docm to wife's pc Windows 10 cannot get microsoft Excel 16.0 object library to remain checked when copying word docm to wife's pc Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #2  
Old 10-29-2022, 06:41 AM
grNadpa grNadpa is offline cannot get microsoft Excel 16.0 object library to remain checked when copying word docm to wife's pc Windows 10 cannot get microsoft Excel 16.0 object library to remain checked when copying word docm to wife's pc Office 2016
Advanced Beginner
cannot get microsoft Excel 16.0 object library to remain checked when copying word docm to wife's pc
 
Join Date: Mar 2022
Posts: 46
grNadpa is on a distinguished road
Default

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.
Reply With Quote
Reply

Tags
object library, references, word 2016



Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot get microsoft Excel 16.0 object library to remain checked when copying word docm to wife's pc Problem with Word Mail Merge VBA - Outlook Object Library not recognized shawnhet Word VBA 2 04-15-2015 07:51 AM
cannot get microsoft Excel 16.0 object library to remain checked when copying word docm to wife's pc 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
cannot get microsoft Excel 16.0 object library to remain checked when copying word docm to wife's pc 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:20 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