| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import Multiple CSV Files from Same Folder into Open Workbook
Thanks in advance for your help here.
I'm trying to automatically import some csv files into my Excel workbook. These files always have the same names and are stored within a folder where the Excel file is open. I need to have each file imported into a specific tab (if it exists). Not every file will be used and won't always be available for import so I'll need the VBA routine to skip and move on. The tabs/worksheets I'd like to import to are called "DataToday", "DataTomorrow", "DataYesterday", and "DataMonthly". The csv files are named something close to the same. Please let me know if more information is needed but I'm hoping this will be enough. Thanks again. Conor Finnegan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to open multiple files from within a folder | Excel Programming | |||
| Code to open multiple files from within a folder | Excel Programming | |||
| Import data from multiple excel files in one folder | Excel Programming | |||
| Open many *.tsv files in folder and import the data into Excel | Excel Programming | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
Threaded Mode
