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

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