| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy A Workbook Automatically
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
| How do I automatically copy data from one workbook to another? | Excel Worksheet Functions | |||
| Copy a Workbook Automatically | Excel Worksheet Functions | |||
| automatically copy values of worksheet into new workbook | Excel Programming | |||
| Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
Threaded Mode
