Write VB6 code to be used with VBA

[avi]

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

 

[Jim Cone]

"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



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