| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Window XP update has caused excel to not operate | Excel Discussion (Misc queries) | |||
| active window | Excel Programming | |||
| Excel 2000 macro runs v.slowly when Excel is not Active Window | Excel Programming | |||
| preventing closure of active excel window | Excel Programming | |||
| Changing Excel Icon in the Active Window | Excel Programming | |||
Linear Mode
