Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
VBA save an object
Hello all
May I trouble your collective wisdom? I need to write a VBA macro that automatically saves to file an object that has already been embedded into the same spreadsheet. Let us call it object 6699 on sheet1 of master.xls. The final file needs to become c:\filename.mp3 I just can't figure out how to do it. Anyone care to have a stab at it? I'd be most grateful Best Sam |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
VBA save an object
As far as I'm aware of this isn't possible!
I just could imagine that you'd copy the object to the clipboard (that should be possible in code) and then grab it manually, e.g. paste a picture into Paint or PowerPoint. Everyone agrees with me? Peter "Samaritan" wrote: Hello all May I trouble your collective wisdom? I need to write a VBA macro that automatically saves to file an object that has already been embedded into the same spreadsheet. Let us call it object 6699 on sheet1 of master.xls. The final file needs to become c:\filename.mp3 I just can't figure out how to do it. Anyone care to have a stab at it? I'd be most grateful Best Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA save an object | Excel Discussion (Misc queries) | |||
save object as jpg or gif | Excel Programming | |||
Excel object - save as csv from Word? | Excel Programming | |||
Can't save chart as object in current sheet | Charts and Charting in Excel | |||
Using vb to create an excel object and save it as a CSV file | Excel Programming |