Use the NAME STATEMENT
Name oldpathname As newpathname
--
Regards,
Tom Ogilvy
"TheRook" wrote:
Excellent, worked a treat.
Now that I have saved the file as a web page and have a folder of all the
pictures is it possible to automaticlly rename them. They have been saved as
image001 image 002 etc.
On the spreadsheet I have now have a list in column A of the image name and
in column B a list of the name I want to call it.
Is it possible to rename tham automatically?
Regards
"Ron de Bruin" wrote:
Hi TheRook
Save you file as a webpage and you will have a folder with all pictures in the workbook
--
Regards Ron de Bruin
http://www.rondebruin.nl
"TheRook" wrote in message ...
I currently have some pictures inserted onto a spreadsheet.
What I am wanting to do is save the individual pictures as either GIF/JPEG
files.
How can I do this?