"GetObject" is the magic word...

http://support.microsoft.com/kb/219151/en-us
"How to automate Microsoft Excel from Visual Basic"
http://support.microsoft.com/kb/302460/en-us
"The Office XP Automation Help file is available for download"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"avi" wrote in message ups.com...
Hello,
I am new in what to seem not an easy task. I'm trying to perform 2
tasks:
Refer in VB6 to the active open workbook.
Refer in VB6 to an userform created in VBA and residing there.
Could i get some help for these 2 specific tasks. Besides that, is
there some documentation about writing code in VB6 that refers to
Excel objects?
Thanks a lot
Avi