Copy A Workbook Automatically

[Guest]

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

Len

 

[Barry-Jon]

CSV files can easily be imported by excel. You can then
programmatically alter the field that is being incorrectly formatted as
a date. I am guessing the field is some kind of number (remember dates
are stored as the number of days (whole numbers) and hours, minutes
etc... (fractions of numbers) from a given date in time (1900 or so) in
excel so sometimes numbers get formatted incorrectly - it doesn't mean
the data has been corrupted in any way so changing the formatting
should do the trick.