How to Operate the active Excel Window with VB6
 

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!

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!