Export embedded Excel file from user form

[XP]

Using Office 2003 and Windows XP;

I can embed an MS-Excel file as an OLE object that appears as an icon on a
user form manually.

Is there a way to programmatically export this file back out of MS-Access
and essentially restore it again?

If so, could someone please post example code?

Thanks much in advance.

 

[Stephen Lebans]

Not sure why you re not simply linking to the external file instead of
embedding it, but anyhow, see:
http://www.lebans.com/oletodisk.htm
NEW - Feb 06/2006 ExtractInventoryOLE.zip A2K or higher ONLY! This
version saves the entire contents of a table containing OLE Objects to disk.
Does NOT require the original application that served as the OLE server to
insert the object. Supports all MS Office documents, PDF, All images
inserted by MS Photo Editor, MS Paint, and Paint Shop Pro. Also supports
extraction of PACKAGE class including original Filename. Contains function
to produce a full Inventory of the OLE field including LINKED path and
Filenames. Uses Structured Storage API's to read the actual contents of the
field.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.