Export embedded Excel file from user form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

XP - 20 Jul 2007 21:58 GMT

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.

Reply to this Message

Stephen Lebans - 21 Jul 2007 03:17 GMT

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.

Signature

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

> Using Office 2003 and Windows XP;
>
[quoted text clipped - 7 lines]
>
> Thanks much in advance.

Reply to this Message