Does anyone know of a way to update the progressbar (increase the value) when opening an Excel file. The code I am using to open the file is: Workbooks.Open ('the name of the file')
Since the file takes about 20-30 seconds to open, I want to add a progress bar on the form. But, since the code can only be read one line a time, the progress bar's value will not change until the Excel file is open. I would like the progress bars value to change DURING opening of the file. Please let me know if you have an answer to this question. If you have some sample code that will even be better! Thanks!
PS - the Timer does not work because code can only be read one line at a time and during run time the code will stop at Workbooks.Open (the name of file) until the workbook open procedure is complete. Is there a way to get around this?