Topic Thread

Expand all | Collapse all

HTTPS using SharePoint and Excel VBO to open an excel workbook

  • 1.  HTTPS using SharePoint and Excel VBO to open an excel workbook

    Posted 12-07-2018 22:31
    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


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

    Posted 05-26-2020 07:40
    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
    ------------------------------



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

    Posted 05-26-2020 08:25
    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
    ------------------------------



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

    Posted 05-26-2020 13:27

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



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

    Posted 05-27-2020 07:16
    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
    ------------------------------