[AccessD] Word Not Closing

...and a "class" solution at that :)

William

--------------------------------------------------
From: "Drew Wutka" <DWUTKA at marlow.com>
Sent: Wednesday, February 25, 2009 5:56 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Word Not Closing

> http://www.la-solutions.co.uk/content/MVBA/MVBA-Clipboard.htm
>
> A clipboard solution for VBA.
>
> Drew
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
> Hindman
> Sent: Wednesday, February 25, 2009 4:42 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Word Not Closing
>
> ...I never found a way within Access vba to address the Windows
> Clipboard
>
> ...but you can avoid the clipboard dialog by setting its contents to ""
> before you quit word.
> ...how to do that is up to you ...ain't exactly an easy thing unless
> someone
> else has found a switch.
> ...you can try using:
>
>    Dim MyData As DataObject
>    Set MyData = New DataObject
>    MyData.SetText ""
>    MyData.PutInClipboard
>
> ...that should require setting a ref to the win forms 2 object
> ...or the Win Scripting Host with vbscript should work as well
>
> ...be sweet if you found a better answer
>
>
> William
> The information contained in this transmission is intended only for the 
> person or entity to which it is addressed and may contain II-VI 
> Proprietary and/or II-VI Business Sensitive material. If you are not the 
> intended recipient, please contact the sender immediately and destroy the 
> material in its entirety, whether electronic or hard copy. You are 
> notified that any review, retransmission, copying, disclosure, 
> dissemination, or other use of, or taking of any action in reliance upon 
> this information by persons or entities other than the intended recipient 
> is prohibited.
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>