Excel CustomDocumentProperties

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

Excel CustomDocumentProperties
Type Missmatch Excel CustomDocumentProperties 
Andrei Smolin


Add-in Express team


Posts: 17953
Joined: 2006-05-11
Hello Michael,

Sorry for missing that point.

I assume you use Option Strict Off. If so, msoPropertyTypeString is regarded as a non-declared variable of the Variant type having no value. Use Office.MsoDocProperties.msoPropertyTypeString instead.

Regards from Poland (CEST),

Andrei Smolin
Add-in Express Team Leader
Posted 30 Aug, 2021 03:55:15 Top
Michael Kaden




Posts: 322
Joined: 2017-11-15
Thank you Andrei for your prompt answer.

This pointed me in the right direction. However to make it work, I have too use:

Type:=Microsoft.Office.Core.MsoDocProperties.msoPropertyTypeString

Thank you & kind regards

Michael
Posted 30 Aug, 2021 04:21:44 Top
Andrei Smolin


Add-in Express team


Posts: 17953
Joined: 2006-05-11
Welcome!

Regards from Poland (CEST),

Andrei Smolin
Add-in Express Team Leader
Posted 30 Aug, 2021 04:23:11 Top