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
------------------------------
