Is there a way to use a hyperlink to a website in VBA which will pass the username and password required by the website?
The URL I am using is going to a secure site, which requires a username and password, to download a csv file. Currently when I follow the hyperlink a popup authentication window opens which stops the macro until the users enters in the values needed. An additional popup then occurs asking if the file should be opened in excel.
I would like to be able to pass the needed credentials without having to compel the user to intervene. Is this possible using the hyperlink method?
Are there other ways to access a csv file for download from a URL?
John Martinez
The URL I am using is going to a secure site, which requires a username and password, to download a csv file. Currently when I follow the hyperlink a popup authentication window opens which stops the macro until the users enters in the values needed. An additional popup then occurs asking if the file should be opened in excel.
I would like to be able to pass the needed credentials without having to compel the user to intervene. Is this possible using the hyperlink method?
Are there other ways to access a csv file for download from a URL?
John Martinez