hi zaphod,
Can you give me sample code for exporting data to text file
and get back.

Client told us, I need to avoid using the paste method as it has a limit of
255 characters, users may fill the "note " field with much more data that
255 characters.



"zaphod2003" wrote
in message ...

There is a way to do this but it's a tad messy.

What you could do is export the data to a text file and then read it
back again. However, could you explain why you don't want to use the
Paste function?


--
zaphod2003
------------------------------------------------------------------------
zaphod2003's Profile:
http://www.excelforum.com/member.php...o&userid=34362
View this thread: http://www.excelforum.com/showthread...hreadid=541440