Thread: Retrieving data from Excel and store it into string variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marsulein marsulein is offline
external usenet poster
  
Posts: 1
Default Retrieving data from Excel and store it into string variable

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

Reply With QuoteReply With Quote