| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing lots of CSV files into an XLS file as different workshee
I need to import a load of CSV files into one workbook so that I can have
everything in XLS format and tidy everything up. The problem is I need to do this to lots of files, and for a lot of workbooks, and to do it manually would take an age. Can anyone suggest a macro that can import CSV files into my workbook, perhaps taking each file name and path from a list file?? Or another method maybe? Thanks in advance, and Happy New Year! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Links picking up values from an older version of linked file | Links and Linking in Excel | |||
| importing data from txt file | Excel Discussion (Misc queries) | |||
| importing multiple text files into the same worksheet | Excel Discussion (Misc queries) | |||
| Help importing text files into individual cells | Excel Discussion (Misc queries) | |||
| Linking files "File Not Found" | Excel Discussion (Misc queries) | |||
Threaded Mode
