Excel Object Model

Add-in Express™ Support Service
That's what is more important than anything else

Excel Object Model
Does the same model apply for VBA and VB .NET? 
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi, everybody

I am a bit confused. I am learning the Excel Object Model.

When I google "Excel Object Model", most of the time I get Excel Object Model for VBA. Rarely for Visual Studio.

So, is there only ONE Excel Object Model - which applies for both VBA and (Visual Studio, VSTO, ADX) ?

Can you give me a good site where I can learn the Excel Object Model which I can use to write my programs (in VB .NET) using ADX?

I found "Understanding the Excel Object Model from a .NET Developers's Perspective" by Ken Getz. Very Instructive, but quite dated (April 2003!)

Thanks
Leon
Posted 04 Jan, 2019 07:33:17 Top
Andrei Smolin


Add-in Express team


Posts: 16956
Joined: 2006-05-11
Hello Leon,

Actually, you see a description of the object model. The object model itself is defined in Office binary files; it can be used by code written in any language. I suggest that you use to the VBA-targeted description as it seems to be more complete.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 04 Jan, 2019 09:49:12 Top
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi, Andrei

Thanks a lot for all your help!

Leon
Posted 05 Jan, 2019 04:38:54 Top