Working with Excel Macro

GAVIN.RUDLING — Fri, 25 Nov 2022 11:36:00 GMT

Hi Team, Trust you are all well and looking forward to the festive season ahead.

I have a slight issue when working with an excel macro file and I am sure it is not a Blue Prism issue at all.
I am hoping someone may have a hint on the problem.

A client has provided an excel macro file, basically just to refresh some data tables and pivot tables linked to their SQL database.
When the client connects to the folder via a Forticlient VPN connection and executes the file, it runs in under 5 - 10 seconds.
However, If I connect via the same VPN and execute the same macro file, it takes between 10 and 15 minutes if lucky and I get quite a few connection timeout errors in the VBA code itself. There are occasions where the run is successful but still very slow.
I have tried the this from The BPC platform and from my local machine with the exact same results.
I am not sure if it is to do with the location where the excel macro file is being hosted.
Anybody have any ideas?

Kind regards
Gavin

------------------------------
Gavin Rudling
Digital Consultant & Developer
Cog3nt
Africa/Johannesburg
0813906789
------------------------------

RE: Working with Excel Macro

ewilson — Fri, 25 Nov 2022 12:22:00 GMT

Track the discussion on this thread:

https://community.blueprism.com/discussion/working-with-excel?ReturnUrl=%2fcontent%2fallrecentposts

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

topic RE: Working with Excel Macro in Product Forum

Working with Excel Macro

RE: Working with Excel Macro