I suggested uses Querytable,Because it is EXCEL own thing, with EXCE
The coordination quite is good, for example: With CopyFromRecord Whe
every one Cell The character cannot be more than 911,etc。
--
bighea
-----------------------------------------------------------------------
bighead's Profile:
http://www.excelforum.com/member.php...fo&userid=2704
View this thread:
http://www.excelforum.com/showthread.php?threadid=46654