Need to loop a macro to save images to file - but save to user defined directory.

Hello all!

I am working on a really useful bit of code that I found on another thread here: http://www.excelforum.com/excel-prog...el-2010-a.html

The following code works perfectly. However, I want to modify it so that I can:

- Allow the macro to work over a number of rows, defined within the macro. E.g I only want it to extract the images in column A up until row 20.
- Allow the user to set a different local directory to download to in range D2, and to this directory, save the images from row 21 to row 40.
- And so on, for another local directory in range D3, and for rows 41 - 60.

Anyone have any idea how I could best acheive this? My original code is below. Many thanks in advance for your help!

Please Login or Register  to view this content.

Hi Jack,

I don't think I was clear enough with my original description.

I've attached a simplified version of my spreadsheet that sets out what I need to do. Basically, I need my macro to run three time against a different range of cells in column A, allowing the user to define a save location for each set of files.

Any further pointers/help much appreciated

After much trial and error, and tweaks to what I originally needed, I eventually got there with this bit of code.

Please Login or Register  to view this content.

Thanks to anyone who took a look :D