How to run vba asynchly

macropod · #1 01-11-2016, 12:48 AM

Quote:

Originally Posted by PRA007

While I got nice answer at: https://www.msofficeforums.com/word-...data-word.html, I thought what is need of such complicated process?

After spending much time with VBA I realized that, if not proper, VBA may be wasting your time rather than saving.

This is example of time wasting VBA.

I'm not sure what you mean by the last remark or what part of the code is 'time wasting'. Furthermore, converting "the httpreq part into a function" isn't going to make things happen any faster or make the code run asynchronously.

PRA007 · #2 01-11-2016, 03:38 AM

I forget to mention best part of my problem here. When I use code supplied by you, I am able to work with other instances of word, while I use my code, I ma not able to do anything with any word until the process is finished.

I know that overall speed will be the same, but will save my time as no need of waiting till process to complete and Meanwhile I can work with other word doc. (even same word doc)

I may be wrong when it comes to literal meaning of asynch method, but what I want is to continue working with word while lengthy process of downloading loads of pdfs from web is underway using vba.

macropod · #3 01-11-2016, 03:56 AM

Quote:

Originally Posted by PRA007

I forget to mention best part of my problem here. When I use code supplied by you, I am able to work with other instances of word, while I use my code, I ma not able to do anything with any word until the process is finished.

That has nothing to do with converting "the httpreq part into a function", though; it's all to do with the fact the code is running a different instance of Word, leaving your other instance(s) available for use by other processes (including you).

PRA007 · #4 01-11-2016, 04:07 AM

So what you suggest?
Should I continue with existing method or convert the HTTP part to function?