![]() |
#2
|
||||
|
||||
![]()
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] |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |
![]() |
eNGiNe | Word | 6 | 12-05-2012 01:05 AM |
![]() |
waltdisneypixar | Excel | 6 | 06-11-2012 12:55 AM |
![]() |
cs_starter | Mail Merge | 1 | 09-08-2011 12:52 AM |
![]() |
shakilhyd | Excel | 2 | 05-17-2010 07:50 AM |