Hi All,

I create an excel object in VB and store the data from the spreadshee
into a local variable called strTemp. However, error occurs when th
data field is larger than 255 characters. Excel automatically truncat
the data to 255 chars and gives out error:

"Arguments are of the wrong type, are out of acceptable range, or ar
in conflict with one another"

Is there anyway to fix this?

Thanx in advance.

Regards,
Ma

--
marsulei
-----------------------------------------------------------------------
marsulein's Profile: http://www.excelforum.com/member.php...fo&userid=1606
View this thread: http://www.excelforum.com/showthread.php?threadid=27520