Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-31-2022, 08:24 PM
Guessed's Avatar
Guessed Guessed 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
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The macros will run faster if they don't have to wait for Excel to open so importing a text file source can be a lot quicker in execution.

Debugging form opening can be problematic since you just get a message that it fails showing the line of code that called the form rather than the line of code in the initialize macro where the problem resides. I usually add breakpoints in that code so I can step through the form code and isolate the issue that way.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 11-01-2022, 05:26 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

Quote:
Originally Posted by Guessed View Post
The macros will run faster if they don't have to wait for Excel to open so importing a text file source can be a lot quicker in execution.
I'm going to mark this as resolved given the viable alternative of code change. The original issue remains a mystery.

Despite escalation, Microsoft has not gotten back to me. Not so surprising. Given their BIOS recommendation, I'd be too embarrassed to contact me too.

Finally your Chrysalis Design LinkedIn page shares a quite impressive bio and professional services. Congratulations.
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 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