Where to find thorough introduction to Excel objects

  • Thread starter Thread starter Michael.Tarnowski
  • Start date Start date
M

Michael.Tarnowski

Hi folks,
I thumbed through several books on Excel VBA programming, but no one
was a satisfying primer or description of all the Excel classes or
objects giving thorough information on their usage and associated
methods.
Most VBA Excel books shows pre-selections of classes and methods.

Does anybody can recommend an thorough internet site, tutorial, or
book for learning?

Thanks
Michael
 
Hi folks,
I thumbed through several books on Excel VBA programming, but no one
was a satisfying primer or description of all the Excel classes or
objects giving thorough information on their usage and associated
methods.
Most VBA Excel books shows pre-selections of classes and methods.

Does anybody can recommend an thorough internet site, tutorial, or
book for learning?
Click to expand...

One of the appendices of this book has an exhaustive listing of the object
model. The appendix is something like 300 pages long.

http://www.amazon.com/gp/product/0470046430?v=glance&n=283155&s=books&v=glance
 
Are you aware of the Excel object model reference and object model map
that's available from the VBA window under the Help menu?

Jeff
 
Are you aware of the Excel object model reference and object model map
that's available from the VBA window under the Help menu?

Jeff
Click to expand...

Dick, Jeff thanks for your hints.
@Dick: I have to more precise: I'am looking for Excel 2003
@Jeff: "Excel object map in the help? - Noop, not aware; where do I
find this? - I have to admit, I'am not very acquainted with the VB
environment.

Thanks Michael
 
Are you aware of the Excel object model reference and object model map
that's available from the VBA window under the Help menu?

Jeff
Click to expand...

Dick, Jeff thanks for your hints.
@Dick: I have to more precise: I'am looking for Excel 2003
@Jeff: "Excel object map in the help? - Noop, not aware; where do I
find this? - I have to admit, I'am not very acquainted with the VB
environment.

Thanks Michael
 
@jeff: "Excel object map in the help? - Noop, not aware; where do I

In VBA, enter "Object Model" in help and choose the "Microsoft Excel
Object Model" topic. Also, you can view all objects and their methods
and properties in the Object Browser (F2 in VBA).

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
@Dick: I have to more precise: I'am looking for Excel 2003
Click to expand...

There's a 2003 version of that book. But the 2007 version will be 99%
compatible if you can't find a 2003 version.
 
There's a 2003 version of that book. But the 2007 version will be 99%
compatible if you can't find a 2003 version.
Click to expand...

Thank you all for your hints and tips
Michael
 
There's a 2003 version of that book. But the 2007 version will be 99%
compatible if you can't find a 2003 version.
Click to expand...

Thank you all for your hints and tips
Michael
 
Back
Top