Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 05-28-2014, 06:25 AM
Sorcerer13 Sorcerer13 is offline Detecting an active instance of Excel from Word VBA Windows 7 32bit Detecting an active instance of Excel from Word VBA Office 2010 32bit
Novice
Detecting an active instance of Excel from Word VBA
 
Join Date: Sep 2012
Location: God's Own County
Posts: 16
Sorcerer13 is on a distinguished road
Default

Paul....

The point I was making is that if you step through the code as previously shown, regardless of the current state of Excel, the code ALWAYS invokes ANOTHER instance of Excel with no Workbook open. Also, the flag "gbooExcelIsRunning" is NEVER set, so using this code I'll always terminate Excel, regardless of its original state.

If, after the
Code:
gxlApp.Visible = True
line I look at the "new" instance of Excel, under the File tab, the only available options are "Open/Recent/New/Help/Options/Exit", and the header in the Excel Window is just "Microsoft Excel", not "Name.Type - Microsoft Excel".

I strongly suspect it's all caused by a setting on my PC, but I'm bewildered (as usual) as to what it could be.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
problem copying active excel table onto word, office 2013 billb Word 2 01-08-2014 05:12 PM
Detecting an active instance of Excel from Word VBA Word vs bookmarks, another instance <g> eNGiNe Word 6 12-05-2012 01:05 AM
Detecting an active instance of Excel from Word VBA www....com does not stay active in excel 2010 waltdisneypixar Excel 6 06-11-2012 12:55 AM
Detecting an active instance of Excel from Word VBA How to create multiple pages, 1 instance of word window cs_starter Mail Merge 1 09-08-2011 12:52 AM
Detecting an active instance of Excel from Word VBA VB Code in Excel Active worksheet shakilhyd Excel 2 05-17-2010 07:50 AM

Other Forums: Access Forums

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