VBA save an object

  • Thread starter Thread starter Samaritan
  • Start date Start date
S

Samaritan

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 save as .XLSX 10
VBA to Move Sheets and save 3
Need help in VBA for embedded object in excel 1
insert objects problem 1
VBA code for "Save as PDF" 1
'Cannot insert object' message when I try to put a button on a worksheet 7
Converting PDF from an Excel Embedded Object 1
PowerPoint Change/update links to new source (PPT with charts & objects linked to Excel) 1

Back
Top