I'm in the process of building a VBA application which will take a number of data files from different sources (.csv, .txt, Access database) and consolidate them into a single Excel worksheet. I will want to do some basic validation on each input file, depending on its source, prior to copying the data to a worksheet.
Where would you start with this ? How should I execute the VBA procedures ? From an Excel workbook itself ? If so, would you suggest a User Form interface, or a worksheet, or an event ? Or is there another way of running a VBA application ?
I'm open to ideas but my programming knowledge is limited to Excel VBA.