Thank Jerry. I agree, I could just hire someone. However, I am trying help myself and others who may want to also tackle this type of issue in the future. This problem is a little harder than what the macro recorder will handle. I need one workbook to create and control a newly created workbook.
The text file would be a simple .txt file that has a 13 rows and 5 columns. Data is tab-delimited. Data would just start in A1
For the formula to place in the destination cell in the newly created workbook, it could be simple as =sum(a1:a13).
The reason I want to automate this is because I would have to open several files and automation is just plain cool.
I have attached a sample text file.
Here is the code for creating a new workbook and asking a user to choose a file
Bookmarks