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