Copying From Closed Workbooks
 

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

Copying From Closed Workbooks
 

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

Copying From Closed Workbooks
 

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

Copying From Closed Workbooks
 

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