Downloading get data hyperlink

Hi all,
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.

Thanks!

By: Kim

3 thoughts on “Downloading get data hyperlink

  1. www.sharps.se

    Hey this is somewhat of off topic but I was wanting to know if blogs use
    WYSIWYG editors or if you have to manually code with HTML.
    I’m starting a blog soon but have no coding expertise so I wanted to get guidance from someone with experience.
    Any help would be enormously appreciated!

Comments are closed.