Results 1 to 3 of 3

Multiple web data imports simultaneously?

This is a discussion on Multiple web data imports simultaneously? within the Excel Questions forums, part of the Question Forums category; Hi there, I have an excel workbook that has 100 tabs in it. Each tab has it's own module/macro that ...

  1. #1
    New Member
    Join Date
    May 2015
    Posts
    2

    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,489

    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

    Default Re: Multiple web data imports simultaneously?

    Awesome, thanks John!

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