Trying to use the Clipboard class in the VB object library

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Conan Kelly - 29 Nov 2006 22:26 GMT

Hello all,

Using MS Office XP on Win XP Pro

I'm using info from a sample program that my prof. was walking us through in my Programming Fundamentals class several years ago.

I set a reference to the "Visual Basic objects and procedures" library (c:\Program Files\Microsoft Visual Studio\VB98\VB6.OLB) in
Access's VBA. When I try to do something like this:

sub testing()
msgbox Clipboard.getText
end sub

VBA/Access locks up (MS's Error Reporting w/option to repair and reopen my current DB).

What is wrong here? Will this library not play nicely with VBA?

Signature

Thanks for any help anyone can provide,

Conan Kelly

Reply to this Message

Allen Browne - 30 Nov 2006 03:07 GMT

Conan, most of us eschew the extra libraries because of the hassles it
causes with references.

You can use an API call to manipulate the clipboard, and it will work
reliably with any version. Details in:
http://allenbrowne.com/func-07b.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello all,
>
[quoted text clipped - 15 lines]
>
> What is wrong here? Will this library not play nicely with VBA?

Reply to this Message

Conan Kelly - 30 Nov 2006 16:58 GMT

Allen,

Thanks for the feedback.

I'll save this post and look this up if I need it in the future. I found a better workaround than what I was trying to do.

Thanks again,

Conan

> Conan, most of us eschew the extra libraries because of the hassles it causes with references.
>
[quoted text clipped - 17 lines]
>>
>> What is wrong here? Will this library not play nicely with VBA?

Reply to this Message