Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Robin,
Thank you so much for the information!! Eddy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Excel Notation for Documentation? | Excel Programming | |||
Look up VBA documentation using Excel Help | Excel Programming | |||
Documentation 4 Excel Web Component | Excel Programming | |||
Excel Object Documentation | Excel Programming |