Excel XP DataObject

[vaneagle]

Hi,

The following code errors on me in XP. Funny thing is is that it works in Excel 97.

The error it gives is: compile error: User-defined type not defined

Dim JunkData As New DataObject ' Declare Variable to clear out clipboard

Any ideas? Is there something I need to add in?

regards,

vaneagle

 

[PHV]

The DataObject is part of MSForms.
So you have to reference the Microsoft Forms 2.0 Object Library.
In VBE, Menu Tools -> References...

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[vaneagle]

Thanks PHV...

I initially had a look for Microsoft Forms 2.0 Object Library but couldn't find it!! So I went to an Excel 97 user and found it straight away. On my pc I actually had to go browsing for the fm20.dll and load it so that it was there.

All is well now. Thanks very much.

vaneagle