Sorry for the late response. Apparently my home machine does not
like the "split" portion. After running it on my work machine it
still give a "0 - Error Occurred in Excel App Process" But now it
only populates one row...


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

That's what I suspected would happen. I suggests multiple instances of
the same entity in the dwg at home. Restore the code to 'Exit For' in
the j loop's 'If..Else' block and try it with your original dwg...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion