Document Level Customization Tutorials and Documentation

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

Document Level Customization Tutorials and Documentation
Where I can find tutorials to create Excel Document Level Customization 
Felipe Gualberto




Posts: 3
Joined: 2017-03-30
Hello,

I'm an Excel developer and now I'm using Add-in Express to develop Office Applications. I've studied a few tutorials of Add-in Express and so far, I've created Application Level COM Add-ins as I was navigating through this site's Learning Center.

I couldn't find any Document Level Customization tutorial for Excel. I'm assuming Add-in Express supports this feature as I've browsed some document level questions in this forum.

Could you provide me some links of tutorials and samples so I can study? This is the most important feature for my daily work - developing custom automatized Excel workbooks for my customers.

Thanks.
http://www.ambienteoffice.com.br
Microsoft Excel MVP
Posted 30 Mar, 2017 15:26:39 Top
Andrei Smolin


Add-in Express team


Posts: 14129
Joined: 2006-05-11
Hello Felipe,

Actually, Add-in Express provides a limited support for document-level customizations. The approach utilized is this: you create an application-level add-in and when it is loaded, you trace the event which occurs when a document (workbook, presentation, etc.) is opened and decide whether your add-in will show its controls for this document. Additionally, Add-in Express provides Excel-specific and Word-specific document-level modules that allow you to connect to controls from Microsoft Forms 2.0 Object Library. These are unmanaged controls.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 31 Mar, 2017 04:06:04 Top
Felipe Gualberto




Posts: 3
Joined: 2017-03-30
Thanks, Andrei.

How can I create a Document Module?

Unfortunately, I think that it's better for me to stick with VSTO?
http://www.ambienteoffice.com.br
Microsoft Excel MVP
Posted 31 Mar, 2017 08:01:52 Top
Andrei Smolin


Add-in Express team


Posts: 14129
Joined: 2006-05-11
In the Add New Item dialog, choose Common Items | Add-in Express Items | Excel | Excel Worksheet Module or Common Items | Add-in Express Items | Word | Word Document Module. Also, there are sample projects: in the archive labeled "Add-in Express for Office and .NET sample projects" at https://www.add-in-express.com/downloads/adxnet.php, you can find ExcelTimeSheet and WordFax sample projects.

Felipe Gualberto writes:
Unfortunately, I think that it's better for me to stick with VSTO?


Yes, I believe they provide more features for document-level customizations.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 31 Mar, 2017 09:51:41 Top
Felipe Gualberto




Posts: 3
Joined: 2017-03-30
Thank you very much, Andrei!
http://www.ambienteoffice.com.br
Microsoft Excel MVP
Posted 31 Mar, 2017 11:39:39 Top