Hi,
Please assist in creating vba code that will automate current task as follows,
- manually open each file to check if complete with volume numbering 200+ accounts.
- It was made by checking value of the ending balance - normal - ist file as againts ending
balance of the next, if values are equal it means files complete,if not incomplete.
Sample content of file
file 1
,,,,,"BEGINNING BALANCE-NORMAL","C","","11602603.58"
,,,,,"ENDING BALANCE-NORMAL","C","","9301134.07"
File 2
,,,,,"BEGINNING BALANCE-NORMAL","C","","9301134.07"
,,,,,"ENDING BALANCE-NORMAL","C","","4907521.54"
File format is text and comma deliminated
Data to look for is located on top- 1st and 2nd row
I got several codes from other forums and tried to edit them to fit my requirements but to no avail.
Because at this point I, cannot create original (made by me) code successfully as my knowlede in vba is limited, My macro programs are just copied from forums here and somewhere else.
Thank you in advance
Ofel
Bookmarks