Looking for documentation/reference to write Excel Macro

[eddiekwang]

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

 

[Robin Hammond]

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

 

[eddiekwang]

Robin,
Thank you so much for the information!!

Eddy