I need a macro to copy a variable amount of between 19 and 600 jpg files from an existing folder to a new folder. The selected image file names will be listed in a worksheet range (A1:A500) and the new folder name will be stated in cell B1. I am already using a macro to generate html pages which are automatically saved in the "B1" folder. The required images need to be saved in the same folder or possibly in a sub folder.
Any ideas?
Any ideas?