Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert pictures
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert pictures
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert pictures
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert pictures
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert pictures
Hi TheRook
You can use this to rename the files in column A to the names in B I assume you have the full path in A and B like this C:\Data\name1.xls and C:\Data\newname1.xls Sub test() For Each cell In Columns("A").SpecialCells(xlCellTypeConstants) If Dir(cell.Value) < "" And cell.Offset(0, 1).Value < "" Then Name cell.Value As cell.Offset(0, 1).Value End If Next cell End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "TheRook" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't insert pictures | New Users to Excel | |||
Insert pictures | Excel Discussion (Misc queries) | |||
Need Help with auto insert of pictures | New Users to Excel | |||
using VBA to insert a column of pictures | Excel Programming | |||
Activesheet.Pictures.Insert | Excel Programming |