DataObject object

[Giulmo]

Hi to all,

I am new to the forum and I am starting to do some vba programming for Excel. I have an Excel 2002 Sp-2 and I am having troubles with the DataObject object type.

I need to copy a cell content to the clipboard and bring it back with a DataObject object (with the DataObject.GetText method) so that I can count the occurrence of a given charachter within that text.

Problem is that while the vba help shows me the DataObject declaration, Excel gives me an error telling me that there is no DataObject type defined and that I need to define it as a user-defined type.

Can anybody help me with that?

Giulio

[Leith Ross]

Hi to all,

I am new to the forum and I am starting to do some vba programming for Excel. I have an Excel 2002 Sp-2 and I am having troubles with the DataObject object type.

I need to copy a cell content to the clipboard and bring it back with a DataObject object (with the DataObject.GetText method) so that I can count the occurrence of a given charachter within that text.

Problem is that while the vba help shows me the DataObject declaration, Excel gives me an error telling me that there is no DataObject type defined and that I need to define it as a user-defined type.

Can anybody help me with that?

Giulio

Hello Giulmo,

I would suspect that the object library has not been registered. An object and it's properties can show up in VBA and still not be registered. Go to the Visual Basic Editor and select "Tools" from the menu. Select References. This will display a box with the object libraries available. Go through and see if the ADO and DAO object libraries are loaded. There is a check box next to each reference.

Good Luck,
Leith Ross