Multiple web data imports simultaneously?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Multiple web data imports simultaneously?

  1. #1
    New Member
    Join Date
    May 2015
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Multiple web data imports simultaneously?

     
    Hi there,

    I have an excel workbook that has 100 tabs in it. Each tab has it's own module/macro that will import the options chain from Google Finance for a different stock, equating to 100 total different options chains.

    Each tab takes about 2.5 seconds to load the option chain in it. Multiply this times 100 and it takes over 4 minutes to process. I'd like to cut this number down, if possible.

    My workbook currently updates one tab at a time and I wanted to know if there is a way to update multiple tabs simultaneously. I.e. 10 or even 100 tabs can be updated all at the same time, instead of updating one at a time in order.

    I would greatly appreciate help with this!

    Thanks!

  2. #2
    Board Regular
    Join Date
    Oct 2007
    Posts
    4,797
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple web data imports simultaneously?

    Welcome to MrExcel forums.

    Yes, it is possible to retrieve data and update multiple sheets simultaneously, using multiple VBScript agents. See Multithreaded VBA – An Approach To Processing Using VBScript | Excel & VBA – Databison and Multi-threaded VBA | Excel Hero Blog.

  3. #3
    New Member
    Join Date
    May 2015
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple web data imports simultaneously?

      
    Awesome, thanks John!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com