cancel
Showing results for 
Search instead for 
Did you mean: 

open workbook command not working

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

------------------------------
Aswin Jagannathan
------------------------------
12 REPLIES 12

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

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


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

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

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,


The excel file is placed in the shared location path

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

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

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


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

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

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

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

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

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


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

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

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

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

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


Hope it helps you out and if my solution resolves your query, then please mark it as the best answer

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

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

yes its the same

For eg:

\\abc\Processname\Input


Thanks

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