Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-23-2025, 05:25 AM
kilroyscarnival kilroyscarnival is offline Troubleshooting Excel VBA performing Word operation Windows 10 Troubleshooting Excel VBA performing Word operation Office 2021
Expert
Troubleshooting Excel VBA performing Word operation
 
Join Date: May 2019
Posts: 363
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by macropod View Post
The issue you're running into is most likely due to the documents concerned being mailmerge main document. You could insert:
wordApp.DisplayAlerts = wdAlertsNone
before:
wordApp.Visible = False
to allow processing to continue but be aware this breaks the mailmerge data connection, which would have to be re-established before the documents could again be used for a mailmerge.
Hi, Paul, and thanks. I tried this, but I didn't think that would be the case, as these old files are not made with mail merge. Many of them were before I started, and I don't think anyone knew how to mail merge here.



But I gave it a shot. And at first, I got a "waiting for an OLE object in another application" error and I thought nothing was happening. Then, the Compress Pictures dialog popped up. (One of the limitations of this in Word is that there is apparently no good VBA bypass for picking "all pictures in the document" and "web quality" vs "print quality", etc. It did eventually work. Despite the fact that I have to be attendant and click those boxes/radio buttons (some are .doc and some are .docx, depending on how old they are.)

Once again, to my VBA rescue! Thanks again, Paul.
Reply With Quote
Reply

Tags
excel 365, object library, word 365



Similar Threads
Thread Thread Starter Forum Replies Last Post
Know-Nothing Excel user needs help with simple Excel operation geobar Excel 2 06-18-2021 10:57 AM
Single Image Selection / Shortcut Key (Mac Excel 2011) Troubleshooting chendric3 Excel Programming 0 04-14-2017 11:04 AM
Excel 2013 two laptops near identical spec performing differently mobile Excel 6 04-04-2016 03:39 AM
Troubleshooting Excel VBA performing Word operation Excel 2011 not performing paste special correctly mzimmers Excel 1 01-04-2011 06:17 AM
Troubleshooting Excel VBA performing Word operation Basic operation of Excel not working! praveen_p Excel 2 04-23-2009 10:21 AM

Other Forums: Access Forums

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