Suspend Excel VBA to allow form to update
Posted on 2011-03-07
I have a long process that grabs workbooks from out Intranet, copies them into a master file locally and save the local workbook. There can be from 25 to 138 worksheets downloaded and I hav on the main form a "countdown" lablel that shouldupdate each time one of the intranet worksheets have been copied locally. It works when I step through the code, but when the code runs, it appreantly is going so fast, the form does not update. How can I get the form to reflect the information as each worksheet is copied?