Visual Basic/VBA Excel/VBA Access

[Kevin Sprinkel]

I am an experienced Excel user and Access application
developer, but relatively inexperienced in programming in
Excel.

I'm somewhat confused on the following. What are the
differences between Visual Basic, VBA Excel, and VBA
Access? If they are different, can you recommend a good
programming reference for Excel?

TIA
Kevin Sprinkel

 

[Guest]

you just need to learn the object model, i:e (application,workbooks,worksheets. range, cells) and the methods, events, and properties associated; other than that, programming in excel is the same as Access. The best way to learn is to create a macro then do some funky stuff and read back the macro created. just realize that macro's don't create the most efficient code. so alot of it can be written more succinctly. Visual basic is a standalone development environment. unlike access a lot of the functionality already built into Access Forms is not there, but it allows you to create more robust apps and dll's.

 

[Smalltalk_vb]

They all have different objects. Access has reports,
table, queries. Excel has ranges, workbooks, worksheets.

Wrox.com is a good source. I'm using Wrox's Excel 2002
VBA Programmer's reference book right now to learn more
object Excel's new objects.

 

[onedaywhen]

Assuming Office2000 (or above) and VB6.0, the *language* (being VBA)
is common to all three.

However, if you've only extensively used one, it can be hard to
separate VBA from the object model(s) provided by defualt by the
individual app. The best way of seeing the 'wood from the trees' would
be to open up the IDE of the app with which you are most familiar
(e.g. the MS Access VBE), open the Object Browser and change the <All
Libraries> dropdown to 'VBA'. This will show the common language
elements. Change to the app's object model (e.g. choose 'Access' from
the dropdown) to see the custom objects that aren't present in the
other apps.

 

[Kevin Sprinkel]

Thanks to everyone for their thoughtful advice.

Kevin Sprinkel