Leon Lai Kan
Posts: 200
Joined: 2018-12-20
|
Hi, everybody
I want to learn the Excel Object model so that I can develop Excel add-ins using ADX and VB .NET.
I have several books on VSTO which are very good at explaining the Excel Object model. I have not read them all.
But I finally chose ADX.
Is the same Excel Object Model (using VB .NET code) applicable for both VSTO and ADX?
In other words, if I want to program Excel add-ins using ADX, can I use my old VSTO books to learn the VB .NET codes?
Is the VB .NET coding the same for both VSTO and ADX?
Thanks
leonlai |
|
Andrei Smolin
Add-in Express team
Posts: 19138
Joined: 2006-05-11
|
Hello leonlai,
In your add-in you use the object model of the application that loads your add-in. An interop (possibly of a different version) is sort of a database view that you use to look at the object model. I suggest that you check https://www.add-in-express.com/creating-addins-blog/2010/03/16/interop-assemblies-late-binding/: this blog explains interops.
Leon Lai Kan writes:
Is the VB .NET coding the same for both VSTO and ADX?
Yes. The difference is: no vsto-targeted namespaces are available with Add-in Express.
Andrei Smolin
Add-in Express Team Leader |
|
Leon Lai Kan
Posts: 200
Joined: 2018-12-20
|
Hi, Andrei
So, in principle I could use my VSTO books to learn how to program Excel with VB .NET, and then apply my knowledge to develop Excel Add-ins with ADX. There are some differences as you say.
Right?
leonlai |
|
Andrei Smolin
Add-in Express team
Posts: 19138
Joined: 2006-05-11
|
Precisely.
Also, note the way you get an instance of Excel.Application in Add-in Express: you access it via the ExcelApp (or HostApp) property of the add-in module. To access that object from another class, you use this construct: {add-in name such as MyAddin1}.AddinModule.CurrentInstance.ExcelApp.
Andrei Smolin
Add-in Express Team Leader |
|
Leon Lai Kan
Posts: 200
Joined: 2018-12-20
|
|