Thanks for the info.
To me I think your best approach would be have a "Stand alone" program. Being you will have different workbooks to open.
Will all of your files be in the same folder in your system? If so it would be easier to program.
Also when you want to run the program will you want to select the "Daily Balance" for that day?