Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-27-2014, 05:56 AM
macropod's Avatar
macropod macropod 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
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try:
Code:
Dim gxlApp As Excel.Application
Dim gbooExcelIsRunning As Boolean
' Test whether Excel is already running.
On Error Resume Next
gbooExcelIsRunning = False ' Flag to record if we start Excel, so we can close it later.
Set gxlApp = GetObject(, "Excel.Application")
'Start Excel if it isn't running
If gxlApp Is Nothing Then
  Set gxlApp = CreateObject("Excel.Application")
  If gxlApp Is Nothing Then
    MsgBox "Can't start Excel.", vbExclamation
    Exit Sub
  End If
  ' Record that we've started Excel.
  gbooExcelIsRunning = True
End If
On Error GoTo 0
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
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 07:56 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