Question

1
Replies
178
Views
RobinT51 Member since 2018 4 posts
Achmea
Posted: 2 years ago
Last activity: 2 years 3 months ago
Closed
Solved

VBA and Pega Excel sessions

Hello Pega community,

I am opening Excel sessions in an automation. The way I do this is through the Microsoft Excel connector (open method).

In the next steps of my process my Excel macro tries to reconize the sheets that were just opened, with the Application.workbooks open method in VBA. The problem is that this VBA method doesn't work when the Excel sessions are opened this way. When I close the Pega Excel sessions and then manually open them, the Application.workbooks open method do works again.

Is there any way to resolve this?

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