| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste dates from CSV file - date format error?
Hi Dave,
Sorry for the delay in replying to your posts. Thanks for taking the time to review my solution. I note your comments re 1904 date system, l wouldn't have thought of that. The csv files are generated by a internet banking system so l dont think it will be an issue but it needs checking out. With regard to your 2nd post the user selects the file to post from the dialog box shown by 'GetOpenFilename'. VBA code is then used to do the data manipulation & copy/paste as per my solution. Once again thanks for your input. Regards Michael beckinsale |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing date format in copy paste | Excel Discussion (Misc queries) | |||
| Date copy, Paste error | Excel Discussion (Misc queries) | |||
| Copy/Paste Special (Date Format) | Excel Discussion (Misc queries) | |||
| Copy-Paste sheets - error in the dates | Excel Worksheet Functions | |||
| copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
Threaded Mode
