How to get the excel file from the link?

[manjarigoyal1975]

I have multiple excel files at the location Index of \\gsm1111.org\Engineering\Tests\Regional Development\elemenT - Today's Reports\Markets\ST-B...

(folder ST-BA has multiple excel files) and I need to pull only one specific excel file Insight_blue.xlsx as input in Alteryx.

I am not sure how to extract that one file. Any help is appreciated.

[Thableaus]

Hi @manjarigoyal1975 

Is this location available in the web? I tried to open it, without success.

Are you using the download tool for that?

Cheers,

[Hollingsworth · Accepted solution]

@manjarigoyal1975 , like @Thableaus I was not able to access the URL in your post.

However, I have written a generic macro that accepts a URL to an Excel file and then a sheet name in that file.

The macro will then download the file into a temp directory and stream the data in the given sheet name. Note, however that the downloaded excel file will be streamed real-time and deleted when the temp directory is cleaned up.