Output embedded object to a file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J Welsby - 24 Mar 2008 19:56 GMT

Have looked high and low - can someone tell me how to output an embedded file
(Word, PDF etc) to a user's hard disk? The files are contained in an
OLEObject field in the source table. Would ideally not have to open the file
first just to save a copy on the user's local PC. Have tried FileCopy,
docmd.outputto etc without any luck. Thanks in advance.

Reply to this Message

Douglas J. Steele - 24 Mar 2008 20:24 GMT

Check what Stephen Lebans has at http://www.lebans.com/oletodisk.htm

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Have looked high and low - can someone tell me how to output an embedded
> file
[quoted text clipped - 3 lines]
> first just to save a copy on the user's local PC. Have tried FileCopy,
> docmd.outputto etc without any luck. Thanks in advance.

Reply to this Message

J Welsby - 25 Mar 2008 02:12 GMT

Thanks Doug. I am aware of Stephan's db (and am duly humbled by it!) but was
hoping for a couple lines of code that could dump a file out to disk. Is
there nothing that is that straightforward? James Welsby

> Check what Stephen Lebans has at http://www.lebans.com/oletodisk.htm
>
[quoted text clipped - 5 lines]
> > first just to save a copy on the user's local PC. Have tried FileCopy,
> > docmd.outputto etc without any luck. Thanks in advance.

Reply to this Message

Stephen Lebans - 25 Mar 2008 03:50 GMT

No.

Signature

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

> Thanks Doug. I am aware of Stephan's db (and am duly humbled by it!) but
> was
[quoted text clipped - 12 lines]
>> > first just to save a copy on the user's local PC. Have tried FileCopy,
>> > docmd.outputto etc without any luck. Thanks in advance.

Reply to this Message