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

Hi Simon

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
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

On 17 May, 15:21, "Ron de Bruin" wrote:
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



wrote in ooglegroups.com...
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- Hide quoted text -

- Show quoted text -

Many thanks that is a great help