Renaming Images files from worksheet.

[simon]

Hi this is a real newbie question but i've trawled the net and cant
seem to find a solution.

I'm trying to write a macro to rename image files and move them to a
new folder. I have a spread sheet with two columns, one product code
and the second image name. I want to take a file from folder "image"
named "image_name.jpg" and move it to folder "job_done" renamed as
coresponding "product_code.jpg" I thought this would be a realy simple
problem and loads of people would already be doing it but I am
strugeling. Any help wolud be very much appreciated.

Many thanks
Simon

 

[Ron de Bruin]

Hi Simon

You can use the Name function in VBA
See http://www.rondebruin.nl/folder.htm

 

[simon]

Hi Simon

You can use the Name function in VBA
Seehttp://www.rondebruin.nl/folder.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm







- Show quoted text -

Many thanks that is a great help