topic RE: open workbook command not working in Product Forum

open workbook command not working

AswinJagannatha — Mon, 03 Jan 2022 05:38:00 GMT

Getting error while using Open workbook VBO command. It says "Unable to execute code stage"

------------------------------
Aswin Jagannathan
------------------------------

RE: open workbook command not working

devneetmohanty07 — Mon, 03 Jan 2022 07:11:00 GMT

Hi Aswin,

This issue most likely occurs due to missing DLL's while the installation of Microsoft Office suite.

Can you try to reinstall or repair the installation for Microsoft Office once and check if it's working?

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant
Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: open workbook command not working

AswinJagannatha — Mon, 03 Jan 2022 07:21:00 GMT

I don't know how to do it. I'm a beginner. How to do it?

Whats the name of the DLL file. Also the excel is .xlsb file.

Thanks,

RE: open workbook command not working

AswinJagannatha — Mon, 03 Jan 2022 07:55:00 GMT

The excel file is placed in the shared location path

------------------------------
Aswin Jagannathan
------------------------------

RE: open workbook command not working

devneetmohanty07 — Mon, 03 Jan 2022 08:07:00 GMT

Hi Aswin,

It can be any of the supporting DLL's which would be difficult to determine. You need to reinstall the entire Office Application setup.

For this you can go to Control Room-> Add/Remove Programs and from there locate Office Application and select either Repair or you can uninstall the application and then Install it again from the Installer file that might be provided to you by your IT team in case you are working for any organisation.

This step might also require some elevated permission or admin access which many times would require you to connect with your IT team depending on the organisation infrastructure.

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant
Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: open workbook command not working

AswinJagannatha — Mon, 03 Jan 2022 08:20:00 GMT

it works well if i place it in my system.But doesnt if the file is in shared path.Looks weird

------------------------------
Aswin Jagannathan
------------------------------

RE: open workbook command not working

devneetmohanty07 — Mon, 03 Jan 2022 08:37:00 GMT

Hi Aswin,

Can you check what type of file path you are providing for that shared drive file. Is it something like "Z:\<filename>". If yes, you should try to give the entire share drive folder path not the mapped directory short name like Z, Y etc. It should work with that.

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant
Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: open workbook command not working

AswinJagannatha — Mon, 03 Jan 2022 08:42:00 GMT

yes sending the full path only(not the mapped path) ...but no luck 😞

File extension .xlsb

when opened from local drive its working fine. But from shared path no 😞

------------------------------
Aswin Jagannathan
------------------------------

RE: open workbook command not working

devneetmohanty07 — Mon, 03 Jan 2022 09:37:00 GMT

Hi,

Can you show us a screenshot of the path you are using there or type the file path in the reply for this comment ? There should not be double quotes in your file path and it should start with "\\" (double backslashes) ideally.

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant
Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: open workbook command not working

AswinJagannatha — Mon, 03 Jan 2022 09:43:00 GMT

yes its the same

For eg:

\\abc\Processname\Input

Thanks

------------------------------
Aswin Jagannathan
------------------------------

RE: open workbook command not working

Neel1 — Mon, 03 Jan 2022 10:29:00 GMT

Hello Ashwin,

if it working for file stored in locally and not for shared drive then it may be access issue.

Are you able to open that file manually from shared path?
and the error message which you have post is the full one or there are few more line with that message?

------------------------------
Neeraj Kumar
Software Engineer
------------------------------

RE: open workbook command not working

AswinJagannatha — Mon, 03 Jan 2022 10:33:00 GMT

I dont think its an access issue.Given full control to that file.

------------------------------
Aswin Jagannathan
------------------------------

RE: open workbook command not working

JerinJose — Tue, 04 Jan 2022 09:32:00 GMT

please check the culture setting of your VBO,
you can refer this link for updating the vbo global code http://portal.blueprism.com/customer-support/support-center#/path/1301681772

------------------------------
Jerin Jose
Technical Product Owner
EY
Asia/Kolkata
*"If you find this post helpful mark it as best answer, .*
------------------------------