Question
Banco Bhd SA
DO
Last activity: 23 Nov 2023 9:36 EST
The given path's format is not supported. (Microsoft Ec)
Hello team,
I have developed a test automation to show you a bug I have in one of the other automations. I have this small flow that I leave attached below where I am trying to open Excel with the Microsoft Excel connector through the Open method, but it generates the following error: "The given path's format is not supported." Below I attach some images of the properties and values of the components to see if it is more intuitive for you to see where I am failing.
I hope you can help me see if I'm making any mistakes, thanks in advance.
Accepted Solution
Updated: 22 Nov 2023 13:36 EST
Pegasystems Inc.
US
@AndyA16965496I suspect that the path is coming back as NULL or something here. Can you add a MessageDialog into the automation before calling the Open method to see what the value of string1 is? From your screenshots, it should be set, and that path should be fine. Make sure that the file is not open before you click your button. You might also enable the FilePublisher for Runtime in the Tools-->Options dialog in Studio. Select "Pega Robot" from the Treeview on the left and expand it to select the "Runtime Diagnostics" node. Select the "File Publisher" in the "Available options and publishers" ListBox and change the "Mode" to "On". Rerun your project and reproduce the issue and in your %AppData%\Pegasystems folder, you can examine the RuntimeLog.txt to see what might be happening. Upload that log after you have removed any personal or proprietary information, and I can take a look.
Banco Bhd SA
DO
Sorry I didn't respond before, I was checking and I realized that I was using another instance of the selected element, in theory it is as if it were another element that is why it does not refer to me at a certain time when executing the process, thank you Mr. Thomas.