voisin1972
New Member
- Joined
- May 5, 2015
- Messages
- 3
Hi,
I have a 15k query to do in a IE object
since every query takes over 5 seconds, I wanted to create 10 .xlsm files, (that I am successful) on each files I created I add into Thisworkbook lines as follow :
I close those 10 Files then re-open them so the macro start querry the webpages, but the 2ns workbook will not open until the 1st one is finish, (as if I had still a 15k querry list.)
how do I get Excel to open 10 of them without waiting for the previous one to complete macro ?
I have a 15k query to do in a IE object
since every query takes over 5 seconds, I wanted to create 10 .xlsm files, (that I am successful) on each files I created I add into Thisworkbook lines as follow :
Code:
Public Sub Workbook_Open() CoRegisterMessageFilter 0&, mlPreviousFilter
FindIPDIssue
End Sub
Public Sub Workbook_Close()
CoRegisterMessageFilter mlPreviousFilter, 0&
End Sub
I close those 10 Files then re-open them so the macro start querry the webpages, but the 2ns workbook will not open until the 1st one is finish, (as if I had still a 15k querry list.)
how do I get Excel to open 10 of them without waiting for the previous one to complete macro ?