Hello,
I have a data set that I'm trying to link to my excel sheet. Right now I have to go to the website and click a link that then downloads an excel file for me to import to my sheet. I'm trying to automate that process.
The problem is that the link address to download that file is a Javascript url and when I try to Get Data -> From Web and paste that url, I get an error saying it's not the correct format.
Is there a different way to make a connection to this link?
Thanks,
David
I have a data set that I'm trying to link to my excel sheet. Right now I have to go to the website and click a link that then downloads an excel file for me to import to my sheet. I'm trying to automate that process.
The problem is that the link address to download that file is a Javascript url and when I try to Get Data -> From Web and paste that url, I get an error saying it's not the correct format.
Is there a different way to make a connection to this link?
Thanks,
David