I am currently using an Access database + frontend to control excel manipulations, so I regularily run excel macros from Access. These excel macro's can take anywhere from 10 seconds to 10 minutes, depending on the size of the excel files that I am working with. As they are running, I would like to show the user what has been done, sort of like a progress bar in Access. I already have a form loading to tell them it might take some time using a DoEvents statement, but I feel this really limits what I can do. Is there any way I can read progress in from excel as it is running the macro?
Question
thevink
I am currently using an Access database + frontend to control excel manipulations, so I regularily run excel macros from Access. These excel macro's can take anywhere from 10 seconds to 10 minutes, depending on the size of the excel files that I am working with. As they are running, I would like to show the user what has been done, sort of like a progress bar in Access. I already have a form loading to tell them it might take some time using a DoEvents statement, but I feel this really limits what I can do. Is there any way I can read progress in from excel as it is running the macro?
Link to comment
Share on other sites
11 answers to this question
Recommended Posts