Question

2
Replies
82
Views
Ed_Lebeau Member since 2016 15 posts
Comptech Associates Inc
Posted: March 13, 2018
Last activity: May 18, 2018
Closed
Solved

How to modify Excel CustomDocumentProperties

I want to add some CustomDocumentProperties to an Excel Spreadsheet. The connector exposes the CustomDocumentProperties as an object, but it is unclear how to Add or Remove a specific property.

In Microsoft's documentation, it says you do this using a Method _Workbook.CustomDocumentProperties.Add(...). It says this Method is in Office.dll.

Well, Pega Robotics substitutes its own version of Office.dll. Using Object Browser, I can see that Add method in Microsoft's version and I can't see it in the Pega Robotics version. If I include the Add method in a script, it says I am missing a reference, which is what I would expect. It is also missing msoPropertyTypes..

Is there a reasonable way to get around this?

***Updated by moderator: Lochan to add SR details***

Robotic Process Automation SR Created
Moderation Team has archived post
Share this page LinkedIn