View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Heiko Schmidtke Heiko Schmidtke is offline
external usenet poster
 
Posts: 2
Default store SHAPE-Object on disk

Hello,

I have an Excel sheet with one or more shape objects (pictures).
I need to programm a little VBA-routine to extract these pictures form the
sheet and store them on disk.

I already know how to extract the SHAPES:

Dim varPicture As Shape
For Each varPicture In ActiveSheet.Shapes
varPicture.Select
Next varPicture

I even know how to store them in the clipboard-device:
varPicture.CopyPicture

But how can I store them on disk. What doesn't work (but explains my problem
well): varPicture.savetofile "c:\myPic.bmp"

Who knows better?

Heiko