Scenario:
I have a template file that i use alot. Normally i have to import several text files into the tabs on the spreadsheet. These text files are the output of another system and though the file name changes there is a consistent 2 letter code at the end of each file that corresponds to a tab on the template. The template has specific column headers on each tab and i normally have to manually enter the data on each tab from each text file using import data and text to columns into cell A2
Question
Can a VB/VBA script be written that would give me a dialogue window that would allow me to specify txt files on my hard drive, which sheet to import them to and what delimiter to use (almost always commas) and format of the cells (always text)?
Any help would be very appreciated.