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?

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" <TheRook@discussions.microsoft.com> wrote in message news:2B7922B7-A518-4549-BCEB-817C5110691E@microsoft.com...
>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?

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" <TheRook@discussions.microsoft.com> wrote in message news:2B7922B7-A518-4549-BCEB-817C5110691E@microsoft.com...
> >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?
>
>
>

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" <TheRook@discussions.microsoft.com> wrote in message news:2B7922B7-A518-4549-BCEB-817C5110691E@microsoft.com...
> > >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?
> >
> >
> >

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" <TheRook@discussions.microsoft.com> wrote in message news:BD597404-41A1-4506-92EC-749B1C6F387B@microsoft.com...
> 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" <TheRook@discussions.microsoft.com> wrote in message news:2B7922B7-A518-4549-BCEB-817C5110691E@microsoft.com...
>> >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?
>>
>>
>>