Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I get the inserted picture's original filename.
I used the following code to insert a picture into a xls file.
ActiveSheet.Pictures.Insert("C:\Documents and Settings\Administrator\My Documents\My Pictures\0ead1e14.jpg") But I want to get this inserted picture's original filename days later. And I want to export this inserted picture to a picture file by VBA code, not by copying and pasting. Can I do it by VBA code. I use the Name property of the inserted picture. But The property return "Picture 1" to me. How can I get the original filename and export it by VBA code. Best Regards John Black |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Auto save replaced my original file and now I need the original? | Excel Discussion (Misc queries) | |||
Inserted Pictures Do Appear | Excel Discussion (Misc queries) | |||
Saving filename same as import filename | Excel Programming |