View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
mdengler[_5_] mdengler[_5_] is offline
external usenet poster
 
Posts: 1
Default Create muliple sheets using querytable


Tom,

Thanks a bunch for the quick response! I appreciate it. I've changed
modified my export code to use "CopyFromRecordset", but unfortunately
when using this method (as well as using a multi-dimensional array), I
run into a situation whereby I cannot import any record greater than
911 characters into an excel cell. Anything less than this amount of
characters works fine.

Ideas?


--
mdengler
------------------------------------------------------------------------
mdengler's Profile: http://www.excelforum.com/member.php...o&userid=32030
View this thread: http://www.excelforum.com/showthread...hreadid=526823