Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
shape object on a userform? | Excel Programming | |||
Saving embedded object to disk | Excel Programming | |||
How to tell wich object/shape was clicked | Excel Programming | |||
XL2000: Shape object events | Excel Programming | |||
Hyperlink within the TextFrame of Shape Object..? | Excel Programming |