Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 10-30-2022, 06:48 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

The document I'm attempting to migrate is a .dotm. Is that what you mean by a template? If so, maybe the the quick parts are moving with it. I don't know because the other issues stop me from getting to the point where the VBA invokes them.

If you're willing to indulge me, here is where I am with the migration.

I believe my .dotm template migration needs to include:
1. Migrating the .docm template to my wife’s Documents>Custom Office Templates folder.
2. Establishing .dotm and Custom Office Template folder as a “Trusted Site”. (see below).
3. Copying an MS Excel file to a (new, properly named path and folder) on my wife’s machine.
3a. Permanently assigning the Microsoft Excel 16.0 Object Library to the Developer>Visual Basic>Tools>Project>References. (see below)
4. Appending my 3 “Quick Parts” Building Blocks to my wife’s normal.dotm.

I’ve done 1, 2, 3 above. And Lance Whitney’s How to transfer Microsoft Word macros to another computer | TechRepublic page deals with point 4.

But…
(3a) Despite enabling the .dotm’s Developer tab on my wife’s PC, check-marking the Microsoft Excel 16.0 Object Library and saving the .dotm, the assignment won’t stick. Subsequent re-open of the .dotm shows Microsoft Excel 16.0 Object Library still not checked.
(2) Originally there were two separate security blocks. I managed to eliminate one of them through MS file level security (though I don’t recall how I did it), but the “untrusted” message persists. When I try to File>Options>Trust Center>Trust Center Settings>Trusted Locations and try to add Documents>Custom Office Templates folder, I get a popup window indicating the location is already registered. But the warning continues to appear.

I am reluctant to proceed for fear of corrupting my wife’s PC as she uses it for her job. On the other hand, I need a backup plan if and when I replace my laptop.
I’m running Microsoft Windows 10 Home Build 19044 on a Dell Inspiron 15-3567 using Microsoft® Word 2016 MSO (Version 2209 Build 16.0.15629.20196) 32-bit.
Wife’s machine running Microsoft Windows 10 Home Build 19043 on an Acer Aspire TC-885 using Microsoft Word 365 MSO (Version 2209 Build 16.0.15629.20200) 64-bit.

A response I received in another forum suggests that Microsoft does not support VBA on Office 365. I find that comment suspect. I suppose invoking a "Contact Us" on the Microsoft site might be the next step. What do you think?
Reply With Quote
 

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 06:50 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