rschechter
New Member
- Joined
- Aug 7, 2009
- Messages
- 1
I'm fairly new to VBA for excel!
I have an html page that I'm opening with excel. It is a very large document which takes around 3 minutes to open. After it is opened I parse the web page in excel and strip out what I need.
What I would like to do is start the workbook.open and while it is working, continue with other activities. Potentially just providing a progress bar so the user does not feel like excel is hung.
Any thoughts on how to do this? Doevents and timer don't seem to work for this application. Need to execute seperate thread for workbook.open?
Thanks!
Ron
I have an html page that I'm opening with excel. It is a very large document which takes around 3 minutes to open. After it is opened I parse the web page in excel and strip out what I need.
What I would like to do is start the workbook.open and while it is working, continue with other activities. Potentially just providing a progress bar so the user does not feel like excel is hung.
Any thoughts on how to do this? Doevents and timer don't seem to work for this application. Need to execute seperate thread for workbook.open?
Thanks!
Ron
