qurtz,

this is great!!!!

The only problem is that I can not find MICROSOFT FORMS 2.0 OBJECT LIBRARY
on my Excel 2003. I do have SP1 and installed O2003PIA. Please help!

thanks again for your help. I have pieces of code working, until it come to
DataObject... :(

"quartz" wrote:

Denis,

Also, I should have pointed out (although it is included in my comments in
the function) that you need to set a reference to "Microsoft Forms 2.0 Object
Library".
Do this by opening the visual basic editor, then goto <Tools then
<References then check the appropriate box.

HTH/

"Denis Petrov" wrote:

Dear VBA gurus

I have data
11111, abc, xxx,
22222, def, yyy
33333, ghi, zzz

I need to create a VBA code to copy vlaue
11111|22222|33333 (yes, that exact format with |) to the cache so user can
Paste, please HELP!!!!

Thanks to all