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
    5,575
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    2 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!

Some videos you may like

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
  •