Thread: How to determine if instance of Excel is running
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Stephen Bullen Stephen Bullen is offline
external usenet poster
  
Posts: 67
Default How to determine if instance of Excel is running
Hi Vic,

"Application.IgnoreRemoteRequests = True" will keep your instance private.
Be sure to set it back to False before you shut down that instance.

FWIW, that will only stop DDE requests (such as when launching a file from
Explorer), but won't stop OLE requests (such as when double-clicking an Excel
file embedded in a Word document or using any other application that uses
GetObject() to find a running instance of Excel to use.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk


Reply With QuoteReply With Quote