software

Our home office in Africa is sending an Excel CSV file. For some reason four
Columns come accross as date field columns when they are not.

I have created a Master Workbook with Macro code behind it. I need to
automatically Copy the Workbook and transfer the daily Excel CSV file from
Africa into the New (or copied) Workbook.

Can this be done or do we need to purchase MSAccess to do it. This is my
first experience with Excel.

Thank You

Lenquot;Lenquot; gt; wrote in message
...
gt; Our home office in Africa is sending an Excel CSV file. For some reason
gt; four
gt; Columns come accross as date field columns when they are not.
gt;
gt; I have created a Master Workbook with Macro code behind it. I need to
gt; automatically Copy the Workbook and transfer the daily Excel CSV file from
gt; Africa into the New (or copied) Workbook.
gt;
gt; Can this be done or do we need to purchase MSAccess to do it. This is my
gt; first experience with Excel.

Call the file .txt, rather than .csv, and when you are importing make the
relevant columns text.
--
David Biddulph