View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default How to Operate the active Excel Window with VB6

To create your own instance of Excel:
Dim ExcelID as Excel.Application
Set ExcelID= New Excel.Application

To link to a running instance of Excel:
Dim ExcelID as Excel.Application
Set ExcelID= GetObject("Excel.Application")

From then on you use ExcelID in places of where Application would be in VBA.

NickHK

"NTorch" wrote in message
...
Hi

I hope I can operate and Control the active Excel Window. but I don't know
how to grasp the active Excel.

Dim ExcelID as Excel.Application

Set ExcelID

Thank you!