Click on a url in sheet and save the file on a folder

Hi,

We have a url in Sheet1!B2, when we click on it, its open and download a file in zip format automatically.

1. We want to create a vba and when we run it, it click on url and save the file in a particular folder and unzip it in same folder

help pls

you can't unzip files with VBA without using API code, I don't believe. It has been asked before elsewhere, and maybe here. But rarely. regarding the other issue, it would be much easier for you to change your default download loc. in your browser program than to try and do something un-necessarily complex like manipulating the download pointer for files in the windows OS. is the URL an internet one? or a file on your local system? I would assume the web? to follow a URL in a cell, that is *already* a hyperlink, you need this:

Please Login or Register  to view this content.

https://docs.microsoft.com/en-us/off...ollowhyperlink

the FSO never works properly either, in this language, in terms of remembering what directory it was last pointed to when used the previous time. that could be useful if you're trying to get a loc. file instead of a web-based one:

https://docs.microsoft.com/en-us/off...mobject-object

ok Adamji.............