Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-16-2018, 09:21 AM
TishyMouse TishyMouse is offline Using VBA code to interact with or interrupt an external macro Windows XP Using VBA code to interact with or interrupt an external macro Office 2007
Novice
Using VBA code to interact with or interrupt an external macro
 
Join Date: Feb 2012
Posts: 22
TishyMouse is on a distinguished road
Question Using VBA code to interact with or interrupt an external macro


I have a macro that is calling another macro in an external workbook (created by a third party so I don't have access to the macro source code). The external macro currently executes and finishes by displaying a 'Done' message box. Is there any way for me to (a) suppress the message box OR (b) pass a command to simulate pressing 'OK' on the message box OR (c) interrupt the external macro at this point?

Excel 2016 on Windows
Reply With Quote
  #2  
Old 01-16-2018, 09:34 AM
TishyMouse TishyMouse is offline Using VBA code to interact with or interrupt an external macro Windows XP Using VBA code to interact with or interrupt an external macro Office 2007
Novice
Using VBA code to interact with or interrupt an external macro
 
Join Date: Feb 2012
Posts: 22
TishyMouse is on a distinguished road
Default

NOte this is cross-posted to https://social.msdn.microsoft.com/Fo...forum=exceldev as I'm not sure of the right site to use. Apologies if this is not correct practice!
Reply With Quote
  #3  
Old 01-16-2018, 01:19 PM
TishyMouse TishyMouse is offline Using VBA code to interact with or interrupt an external macro Windows XP Using VBA code to interact with or interrupt an external macro Office 2007
Novice
Using VBA code to interact with or interrupt an external macro
 
Join Date: Feb 2012
Posts: 22
TishyMouse is on a distinguished road
Default

Answered at https://social.msdn.microsoft.com/Fo...forum=exceldev
Reply With Quote
Reply

Tags
vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using VBA code to interact with or interrupt an external macro VBA Macro code help get4hari Excel Programming 8 09-26-2015 10:33 PM
Using VBA code to interact with or interrupt an external macro Looking Again for Another Code/Macro rsrasc Word VBA 5 11-16-2014 05:47 AM
Help with external links using Web query/Add-in/VBA Macro tmaster81 Excel Programming 0 07-27-2014 11:24 PM
Using VBA code to interact with or interrupt an external macro Macro - Get External Data From Web Wries Excel Programming 1 10-31-2012 08:00 AM
How interact with IE using VBA. velkanesh30 Excel Programming 0 06-09-2011 10:58 AM

Other Forums: Access Forums

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