![]() |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
|
||||
|
||||
|
Thanks for the heads up on the typo (now fixed). As for the other matter, you are no doubt aware that quick parts cannot be stored in a document. If you plan on sharing the document widely, you will certainly need a different approach - probably by changing the document to a template, which can store such data. The late binding will also be required to overcome the compatibility with different Excel versions.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
#2
|
|||
|
|||
|
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? |
|
| Tags |
| object library, references, word 2016 |
| Thread Tools | |
| Display Modes | |
|
|
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 |