Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |||
cannot edit and save | New Users to Excel | |||
cannot edit and save | Excel Worksheet Functions | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Can't save chart as object in current sheet | Charts and Charting in Excel |