i have two different loops that bring in data from different web pages via web query in two different sheets in a workbook, is that possible to run two loops together?
what i want is when a web page is brought in via web query in one sheet, then at the same time another loop bring in one web page, and then ist loop resume and so on.
Running Two Loops Together VBA
-
-
-
Re: Running Two Loops Together VBA
Sounds like what you want is to thread the Excel VBA procedures? Not as far as I know directly within VBA.
-
Re: Running Two Loops Together VBA
i've come to know, that two loops can't be run together in vba, is it possible to run them one after the other? means when a page is brought in via web query in one sheet via one loop, then the other loop bring in the other url from its list in another sheet? and then the cycle continues
-
Re: Running Two Loops Together VBA
As long as your not talking threading then yes they can be done. It all depends on how you implement it. If you have something working and need help fixing it, you need to attach a sample indicating where the failure is and what your expectations are.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!