We’re running Microsoft Office 2010 at work. I have a need to open several CSV files as multiple tabs in a workbook . I know I could use Get External Data/From Text on the Data tab to populate each worksheet but that seems like a bit more work since it has to ask each time what format the file is in. If I merely click on the file it opens in Excel properly as a CSV file, formatted properly, but opening multiple CSV files opens multiple Excel workbooks and I’d like to keep these are multiple worksheets in the same workbook. Is there a way to do this? This is a process I’m creating for a co-worker and want to make it as simple as possible.
TIA
Rob
