Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
avi avi is offline
external usenet poster
 
Posts: 195
Default Write VB6 code to be used with VBA

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Write VB6 code to be used with VBA


"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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
could someone write me a VB code? thanks Morgan New Users to Excel 6 March 10th 10 01:20 PM
Write code to Write Code Kstalker[_43_] Excel Programming 6 November 25th 05 12:30 AM
Code to write out all lines of code davidm Excel Programming 3 August 5th 05 04:26 AM
How can i write TSR code A-Design Excel Programming 5 September 29th 04 05:26 PM
Using VBA to Write VBA code SB Excel Programming 10 January 23rd 04 02:01 PM


All times are GMT +1. The time now is 01:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"