I would go to the VB Editor, then F2 to open the object browser, and search
for DataObject to see which library contains this object. In XL2000 it's in
the MSForms library, and you may need to set a reference to its counterpart in
XL2003.
So I've got this compiling and running in Word under Office 2003, but it
doesn't clear the clipboard for me. I copy several items, show the clipboard,
see them. Then run this macro, and they remain there. Am I missing something?
I'm also looking for such a procedure or method. I'm calling Excel from
Access and I notice that the suggested code clears the Excel clipboard but
not the contents of the clipboard from Access...If I check the clipboard from
Excel, it is in fact cleared, but if I switch to Access the clipboard there
still has the contents. I need to clear both. Anyone have a suggestion on how
to do that?
This worked for me (fixed the User-defined type not defined ERROR). What's
interesting is that I couldn't find the library (Microsoft Forms 2.0 Object
Library) in my list of references, but once I added a form as Dave suggested
below, it appeared at the top of the list and was checked, and then after I
deleted the form it was still there and checked and my macro now works.
Thanks!
Keith
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.