I get 10 excel files, 1.xls, 2.xls, 3.xls, ... 10.xls, summary.xls
I need to open each file, get update and close it in ascending order.
Does anyone have any suggestions to performance this tasks automatically
through one action? if not, I have to update each file manually, which takes
me 30 minutes to do that. Does anyone have any suggestions?
Thank you in advance
Eric