Open Excel file on OneDrive using wildcard

  • Hello,

    I need to open many files on one specific OneDrive path that have the following path format:

    'Generic OneDrive path' + 'File name that depends on the cell value in C6' + '.xls' + 'path from OneDrive that need to be = to wildcard'.

    I tried as below but it opens a webpage error. Please note that I used descriptions in the path file that doesn´t correspond to the real path.

    It works if I don´t use the wildcard, But then it´s useless for the aim I am trying to reach.

  • I fixed it. it has worked using the beginning of the word in the link with no wildcard. Even though it seems the best way is to use SharePoint metadata to tag the documents.

    Thanks all anyways.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!