Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-09-2024, 11:34 AM
Alexander40 Alexander40 is offline Word Macro calling Excel, back to Word Windows 11 Word Macro calling Excel, back to Word Office 2019
Novice
Word Macro calling Excel, back to Word
 
Join Date: Apr 2024
Posts: 1
Alexander40 is on a distinguished road
Default Word Macro calling Excel, back to Word


I have a word macro that calls and Excel macro. But I haven't figured out that once the Excel macro is done, how do I pass control back to the Word instance? And subsequently, after I go back to word, how do I go back to the already existing instance of Excel opened by Word?

Regards,
-Alexander40
Reply With Quote
  #2  
Old 04-09-2024, 03:40 PM
Guessed's Avatar
Guessed Guessed is offline Word Macro calling Excel, back to Word Windows 10 Word Macro calling Excel, back to Word Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,980
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

I think we need to see what your code is doing.

The Word macro wouldn't just stop because it ran a line that opened Excel so something else must be going on. If you opened Excel with your code, did you set it to be Visible?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
word to excel



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calling macro from loop-all-files macro only opens one file Peterson Word VBA 0 03-27-2021 07:58 PM
Calling a macro from a template using OnAction sg11 Word VBA 2 04-30-2018 11:43 PM
Word Macro calling Excel, back to Word Calling Sub Routine for Formatting recently Created Word Document rpb925 Word VBA 12 03-31-2016 03:14 AM
Word Macro calling Excel, back to Word Macro Needed To Convert Text in Word to Plain Text and Back to Word rsrasc Word VBA 5 12-18-2015 07:13 AM
Word Macro calling Excel, back to Word Calling a macro in powerpoint from command line SeattleITguy PowerPoint 4 11-26-2014 01:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft