I have embedded files in an Excel spreadsheet that I would like to save to disk using a macro. I can handle the OLE Objects if they are Excel files but not others. I tried copying the object into memory and that works. I can then right-click in a folder and paste the file. Is there a way to do the paste using a batch file.

Better yet, is there a way to save the embedded OLE object to disk using VB code within Excel?

Thanks in advance,

Joseph

Hi,

you can try this code.

Set objHTML = CreateObject("htmlfile")
ClipboardText = objHTML.ParentWindow.ClipboardData.GetData("text")
MsgBox ClipboardText