I have been editing and opening manually a hyperlink: http://19…../…../…..parameter=TRUE
And my default browser will open the “interface.json” file as a txt-file in Notepad.
After that I can search all needed information by using Notepad search.
That is ok.
Now I want to automate the tasks (edit, download, search, etc.) by using a Excel 2010 macro.
Only problem is that I don’t know how to download (by using Excel macro) the file (which is hyperlink) http://19…../…../…..parameter=TRUE and save it as “C:Tempinterface.txt”, without using a browser.
Can you help me, but notice the hyperlink is provided by external service provider and that is why I can change only parameters of the hyperlink, I cannot modify the format of the hyperlink, for example I cannot give .txt extension.