Looking for documentation/reference to write Excel Macro
 

Hello,
I am trying to write some Excel Macros. I have some experience in VB,
but I am have trouble in referencing Excel objects in my VB code.

Can someone tell me where I can find documentations on that? I tried
Excel help and VB Help. Neither contains the information I was looking
for to write my Excel Macro.

Thanks you in advance,
Eddy

Looking for documentation/reference to write Excel Macro
 

Eddy,

Are you looking for documentation on automating Excel from VB, or for
general VBA documentation? If the latter, then make sure you have the VBA
help file installed - it's an optional part of the Office setup process -
and check out the object browser in the Excel VBA editor by pressing F2.
This is also a good place to start for general tips: www.j-walk.com

If the former, it depends a lot on what you are trying to do. Stephen
Bullen, Rob Bovey and John Green's new book has a section on ActiveX
controls and com add-ins, but it's not for the beginner. Or have a look
through the archives in this group searching on Com Add-ins for some general
links.

Robin Hammond
www.enhanceddatasystems.com

wrote in message
ups.com...
Hello,
I am trying to write some Excel Macros. I have some experience in VB,
but I am have trouble in referencing Excel objects in my VB code.

Can someone tell me where I can find documentations on that? I tried
Excel help and VB Help. Neither contains the information I was looking
for to write my Excel Macro.

Thanks you in advance,
Eddy

Looking for documentation/reference to write Excel Macro
 

Robin,
Thank you so much for the information!!

Eddy