Macro to open hyperlink and save the file

[kt090678]

Hi

I have a excel spreadsheet which has 100's of hyperelinks in column H

When I click on hyperlink it opens in Internet explorer and prompts the dialog to open save or cancel

I have to save the each individual file eveytime and all these files are in Tiff format

Can somebody help meacro for this

thanks

[OllieB]

Create a module and copy & paste the code below

Please Login or Register  to view this content.

PS. You will need to amend the code somewhat to get the URL from the hyperlink. If you need further assistance please post a copy of the workbook

[:) Sixthsense :)]

@OllieB,

Code of URLDownloadToFile() is missing

[OllieB]

@OllieB,

Code of URLDownloadToFile() is missing

The URLDownloadToFile is a function in a Windows DLL. See the private declare statement just above the sub routine.

[:) Sixthsense :)]

Oops... Thanks for the info and correction

[kt090678]

Hi Forum Guru,

Thank you for providing this macro. I have pasted the hyperlinks in column A and pasted the name the file should be saved with in Column C.

When I Execute this macro files are saved in the directory which I have choosed however the only problem I am facing is the files are not saved in Tiff format.

The file type is shown as File and when I click the to open it prompts to select the file type to open the image and in turn I am selecting the Tiff format to open the file.

Do we have a solution for this and one more quick question is instead of saving the file in default folder can we save the file by choosing the option to save (file save window option)

Once again thanks for all your help

[OllieB]

The missing extension would occur when the file name provided in column C does not contain an extension. Either add the desired extension to the file name, or change the code to automatically append the ".tiff" to the file name. You specified having hundreds of hyperlinks, prompting where to save every single one does not make sense.

[kt090678]

Excellent help on this thank you very much.

One last request files are saved in default location, is there a possibility where I can choose the path to save the files like file open window this will help me alot

[OllieB]

You could introduce the following code in the solution to prompt you for the directory whether the objects should be saved

Please Login or Register  to view this content.

Note that you will have to declare strTargetFolder variable and use it in the call of URLDownloadToFile to replace the current constant used for the path value

[kt090678]

Hi

I am sorry but I could not understand how do I use the above code, as per the above note I have declare strTargetFolder, I am bit confused how do I use this , please advise

[OllieB]

Try

Please Login or Register  to view this content.

[OllieB]

Try

Please Login or Register  to view this content.