Download/Save webpage images to file using VBA

I had originally asked for a response to this question over at MrExcel Board, some days ago but the solution does not seem to fix the problem. I was hoping maybe someone here could shed some light on getting this macro to work.

I tried using the following

Please Login or Register  to view this content.

to get these files which are listed in the A column in a new workbook with the sheet being Sheet1

117427934569752sm
117428128343967sm
117428291462196sm
117428380391871sm

and the only thing that has ever showed up was a .jpg file with no name and with no preview.

Is there something that I am missing to get this to work?

UPDATE:
Not sure what was going on but I took the above code and moved it from personal.xlsb into a separate workbook and voila it worked

Please Login or Register  to view this content.

What value is URLDownloadToFile returning? See http://msdn.microsoft.com/en-us/libr...=VS.85%29.aspx.

URLDownloadToFile is meant to be called as a function returning a value so that you (the code) can examine the value. Like this, but apply it to URLDownloadToFile:

Please Login or Register  to view this content.