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!
|