I'm trying to modify some already-existing VBA/Access code to put some text
in the clipboard. Now, in Excel I just create a DataObject and use its
built-in methods SetText and PutInClipboard; it's very simple. But when I
try that in Access, I can't seem to create the object. Is there something
obvious I'm missing? The appropriate object library is checked, and the VBA
editor is properly capitalized "dataobject", so apparently it can see it.
Yet I'm not allowed to "Dim cb As New DataObject" nor to "Set cb = New
DataObject"; it says I'm not allowed to use "New" in that context, though it
works fine in Excel. What secret words must I utter to get it to work?
Anyone know?

On Tue, 19 Jan 2010 21:33:01 -0800, Bob Bridges
<(E-Mail Removed)> wrote:

I'm not sure - you kept the library name secret which makes it
difficult for us to help you.
Here is an alternative method (actually, two):
http://www.mvps.org/access/api/api0049.htm

-Tom.
Microsoft Access MVP


>I'm trying to modify some already-existing VBA/Access code to put some text
>in the clipboard. Now, in Excel I just create a DataObject and use its
>built-in methods SetText and PutInClipboard; it's very simple. But when I
>try that in Access, I can't seem to create the object. Is there something
>obvious I'm missing? The appropriate object library is checked, and the VBA
>editor is properly capitalized "dataobject", so apparently it can see it.
>Yet I'm not allowed to "Dim cb As New DataObject" nor to "Set cb = New
>DataObject"; it says I'm not allowed to use "New" in that context, though it
>works fine in Excel. What secret words must I utter to get it to work?
>Anyone know?

see http://www.mvps.org/access/api/api0049.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Bob Bridges" wrote:

> I'm trying to modify some already-existing VBA/Access code to put some text
> in the clipboard. Now, in Excel I just create a DataObject and use its
> built-in methods SetText and PutInClipboard; it's very simple. But when I
> try that in Access, I can't seem to create the object. Is there something
> obvious I'm missing? The appropriate object library is checked, and the VBA
> editor is properly capitalized "dataobject", so apparently it can see it.
> Yet I'm not allowed to "Dim cb As New DataObject" nor to "Set cb = New
> DataObject"; it says I'm not allowed to use "New" in that context, though it
> works fine in Excel. What secret words must I utter to get it to work?
> Anyone know?