Getting Started

View Only

last person joined: 21 hours ago

If you're new to Blue Prism, we'll help you get started.

Cant open Excel WB // NameConflict

Niklas Franke posted 09-07-2023 12:24

Hello together,

currently i have a really annoying problem, that i cant fix by myself. I am working with Excelfiles from a shaerpoint and to work with them, i mapped the SharePoint to my Desktop. I copy the original File to a tempfolder, insert the new data and replace the oiginal with the new one, if the process had no errors. But in aprox. 80% of the cases, i got the Errormessage: "Could not execute code stage because exception thrown by code stage: Open Workbook took more than 30 secs.". And when i look at the Files, i see this message:

Before i open the Workbook, i kill every Excel Process and i know, that this error should have something to do with a Filter or a Macro in den File, but i tried really a lot and i still cant figure out, how to solve this problem.

I really hope, that you can help me.

Harish Mogulluri posted 09-08-2023 00:03

HI Niklas Franke,

Default time out for open work book is 30 seconds I think if you are using the latest VBO from digital exchange you can increase the time out value.

regarding the conflict related to the excel. Refer below thread from microsoft.

https://support.microsoft.com/en-gb/office/why-am-i-seeing-the-name-conflict-dialog-box-in-excel-f9251985-dbde-4030-86d8-e90775e79952#:~:text=If%20you%20are%20seeing%20the,that%20has%20similar%20named%20ranges.

Niklas Franke posted 09-12-2023 08:17

Hello @Harish Mogulluri, even if i would put the Timeout to 1 hour, it would not change that the file cant be opended through the Message. The Link you have sent is for InterestRates but i get the _FilterDatabase message. Even when i try to open the File by myself i see the Message, but when im open it directly frotm the sharepoint i will not get it. I really dont know how to solve it. I can type a new name for the Database manually but i will get the message again, if a cowoker worked with the file and i would have to type a new name again. I think its a problem, because the data is shared..

Harish Mogulluri posted 09-12-2023 14:56

Hi Niklas Franke,

I refered about the behavior of time out in my previous comment, But I certainly understood the issue you noticed is not related to time out.

Not sure why it is openeing Intrest rates. for me it is opening below sites which explaining about the issue you encountered

Niklas Franke posted 09-14-2023 11:49

Hi @Harish Mogulluri,

ive see the answers from mircosoft and many forums, but i just dont get it. When i open the File manually, the Message almost never appears, but when i try to open it with Blue Prism, its like 80% and BP cant open the File. I dont copy or do anything.. I have the feeling, that the Problem appears, because i mapped the Shaerpoint as a local Folder + often i have to open the folder first manually, because BP otherwhise cant find any Files in it..

Even if i enter a new name, i cant find it in the Namemanager and i cant do that everyday. I also think, that the message appears, after an other employee has worked and filtered with the Data. They reset the setted after they are done, but still, the _FilterDatabase message should have something to do with it..

Martin Garcinuño posted 09-18-2023 16:42

I am having exactly the same problem, and every day I have to manually run the robot because another employee uses the filters and breaks the process, please let me know if you found a solution

Niklas Franke posted 09-19-2023 09:28

Hello @Martin Garcinuño, i found a workaround for that. If the Open stage gets an error, i attach Excel and spy for the NameConflict window. Then i write a unique name into the texbo like Today() (current Date or use Date+Time) and klick okay. If you have more the one File, that you want to open simultaneously, you have to deatach the Excel process you used before and attach the new, second Excel process, so the bot can finde the new NameConflict Textbox. For that, i save the Process ID PID from the first process and make sure, that the attached second Process is not the same PID.

I hope that helps.