Hi,
I have a fairly complex workbook that processes transactional data row by row. The dat arrives as a CSV (using tab delimiters). When I have the main workbook open and I use File / Open to import it, excel always places it in a fresh sheet. Then I have to copy/paste the data into the appropriate sheet of the main workbook. As I developed the workbook for someone that decidedly non-tech savvy there are frequent mis-steps in the import/copy/paste operation. I'm wondering if any one can help me to achieve the following.

The data CSV is placed on the desktop with a specific filename.
The main workbook is opened up and a VBA command button in the workbook imports the text file (into a specific sheet starting at a specific cell) starting at line 2 in the file and continuing until the first non-numeric value destined for Column A in the main workbook.

Is this possible?

Thanks.