Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy a Workbook Automatically
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy a Workbook Automatically
"Len" wrote in message
... 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. Call the file .txt, rather than .csv, and when you are importing make the relevant columns text. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Rows to another Sheet Automatically | Excel Worksheet Functions | |||
backup copy of a workbook | Excel Discussion (Misc queries) | |||
How do I copy the information from one workbook to another? | Excel Discussion (Misc queries) | |||
Copy sheet - Break Links to Old Workbook - Retain Formula. | Setting up and Configuration of Excel | |||
How can I Copy cell names from one workbook to another? | Excel Discussion (Misc queries) |