New to Excel programming and just need advice on direction to take with this first project so that I can better research questions, etc. An accounting program creates an Excel file in a Windows directory that we need to manipulate and then automatically create a .TXT file from it. The changes we need to make include things such as:
1. Adding a column of data (the same account number, for example). The data would on go as far as the last row.
2. Inserting a decimal point in a column that contains a number already -- to reflect a dollar value.
3. Deleting columns we do not want in the file

There are other changes but this is the basics right now.

So, should we be basing our research on what to do when the file opens ( a user will have to either click on this file or we would like to possibly create a scheduled task to open the file)?

Would we be creating macros to accomplish these file changes?