topic RE: HTTPS using SharePoint and Excel VBO to open an excel workbook in Product Forum

HTTPS using SharePoint and Excel VBO to open an excel workbook

CollinHuber — Fri, 07 Dec 2018 22:31:00 GMT

Hello, I am attempting to open an excel workbook held in sharepoint via the Excel VBO object. The process I've created is able to successfully use the object to navigate to the sharepoint link, collect the file names, pull them in to a collection, and place them in a data item. Furthermore, the date item the process is using correctly pulls the file path from the object. The error message reads "' ERROR: File Not Found : File: [URL to file] does not exist or is not a file." I've validated that this link is not dead and is active. Are there any known solutions to this issue? Regards

RE: HTTPS using SharePoint and Excel VBO to open an excel workbook

AP.Philippa — Tue, 26 May 2020 06:40:00 GMT

Hi Collin,

Have you already been able to find a solution to this issue?
If so, I would be really grateful if you could share this solution with us as we unfortunately are running into the same error when trying to open an Excel file via the SharePoint URL.

Many thanks in advance!

Arthur

------------------------------
Arthur Philippa
RPA Developer
Port of Rotterdam
Europe/Amsterdam
------------------------------

RE: HTTPS using SharePoint and Excel VBO to open an excel workbook

MichalSzumski — Tue, 26 May 2020 07:25:00 GMT

Hi,

The easiest solution that I know is to map SharePoint folder as network drive and then open it (I always prefer to download it locally and work there to avoid latency) using Excel VBO.

If you don't want to do that then you can somehow disable/change sub-page that verifies in "Open Workbook" action if file exists (it seems that currently it cannot handle URL location)

Best regards
Michal Szumski

------------------------------
Michal Szumski
RPA developer
Rockwell Automation
Europe/Warsaw
------------------------------

RE: HTTPS using SharePoint and Excel VBO to open an excel workbook

AP.Philippa — Tue, 26 May 2020 12:27:00 GMT

Hi Michal,

Thanks for your suggestion!

Just tested and when the page VerifyFileExists is disconnected from the Open Workbook action logic, the robot is successful in opening the Excel file using the URL of the SharePoint File. So thanks again!

Currently we have our SharePoint document library mapped to a network drive. However, I fear that this is not a permanent solution as connection of the mapped drive seems dependent on IE Explorer. As my company is planning to phase out IE in the near future, we are looking into new ways of working with (Excel) files located on our SharePoint document library.

One potential solution we currently are exploring is the SharePoint Document Library API (available on the DX). Do you have experience working with this API? If so, do you know whether it is possible to use this API to extract the URL of an Excel file and subsequently open this file using the Open workbook action from the Excel VBO?

Many thanks in advance!

Best regards,

Arthur

------------------------------
Arthur Philippa
RPA Developer
Port of Rotterdam
Europe/Amsterdam
------------------------------

RE: HTTPS using SharePoint and Excel VBO to open an excel workbook

MichalSzumski — Wed, 27 May 2020 06:16:00 GMT

Hi Arthur,

What do You mean that this solution is dependent on IE?

Regarding SharePoint API - we are going to work on this after BP upgrade as our version currently doesn't support skills.

Best regards,
Michal Szumski

------------------------------
Michal Szumski
RPA developer
Rockwell Automation
Europe/Warsaw
------------------------------