Find images in a Excel document.. How !!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way that i can find an image in my Excel document. I have a client who build a large document and i need to reformat that file into a DB application.

Any suggestions or link i can read from ??

thanx
 
LNHockey said:
Is there a way that i can find an image in my Excel document. I have a
Click to expand...
client who build a large document and i need to reformat that file into a DB
application.
Any suggestions or link i can read from ??

thanx
Click to expand...


Pictures appear in the the shapes collection

The code below lists all shapes by name on a worksheet and outputs their
type

Dim mywksht As Worksheet
Set mywksht = ActiveSheet
Dim myshape As Shape

With mywksht

For Each myshape In .Shapes

Debug.Print myshape.Name & "+" & myshape.Type

Next myshape

End With

On a sheet with one command button and and two pictures
the output would look like this

Picture 1+13
Picture 2+13
CommandButton1+12

Once you have the picture object you have various methods
you can use including copy

Keith
 
Back
Top