Hi Mike

You can use this
http://www.rondebruin.nl/copy7.htm

Or open the files
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Mike" wrote in message . net...
Thanks for the reply Ron. It's actually your macro that I was experimenting with. Are there no ways around this problem?

Thanks,
Mike
"Ron de Bruin" wrote in message ...
You use ADO I think and yes this is a limitation

See my site for other examples
http://www.rondebruin.nl/tips.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Mike" wrote in message et...
Hi,
I have a macro which pulls columns of data from closed workbooks in for example C:\Data. Everything works fine except for one
column which could have numbers and text. This is a Bill of Materials application and that column contains quantities except
when the quantities are to be determined - then there is a "TBD" in that column. From my understanding, Excel will bring in
whatever the majority data type is in the column. I cannot change anything in the closed workbooks I am using. If this is truly
a limitation of Excel, does anyone have any ideas how to get around it? Your responses are appreciated.
Mike