+ Reply to Thread
Results 1 to 2 of 2

Emulating multithread in VBA/macro (creating multiple instances)

  1. #1
    Registered User
    Join Date
    03-31-2019
    Location
    RI, USA
    MS-Off Ver
    MS Office 2013
    Posts
    1

    Emulating multithread in VBA/macro (creating multiple instances)

    Hello All,
    What I am trying to do is write a VBscript to create a VBA-threads (open/create 2 instances) of a Master.xlsm file to run 2 independent subroutines/functions at the same time [2 cores or threads] and then write the results back to the master.xlsm file. As these subroutines are very time intensive (takes 24 hours to complete in sequence).

    What I have is a Workbook called Master.xlsm (MS Office 2013) which consists of:
    Sheet1: contain data-entry for Table-A (used for subroutine 1) and Table-B (used for subroutine 2).
    Sheet2: contain result-entry in Column-A (by subroutine 1) and Column-B (by subroutine 2).

    Note: Master.xlsm also allow subroutines 1 & 2 to write to Sheet2 (Column A & B) while running.

    Can anyone help me write a basic VBscript to be used as a reference or point me to the right direction?

    Thank you,
    ZeroKool

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Emulating multithread in VBA/macro (creating multiple instances)

    Hello ZeroKool, I have long been fascinated by a multi threading example provided by Daniel Ferry. Have a look at http://www.databison.com/multithread...sing-vbscript/
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating multiple calendar instances through macro based on cell references
    By winwall in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2014, 08:39 PM
  2. [SOLVED] Macro causes multiple instances of Excel in Task Manager
    By klonbeck in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-14-2013, 01:55 PM
  3. [SOLVED] Complex VLOOKUP, multiple instances vertical, return subsequent instances horizontally
    By Miles_2804 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-12-2013, 11:54 AM
  4. [SOLVED] Flight Log Fix - Multithread
    By ask4help in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-12-2012, 12:45 AM
  5. Macro to sum multiple instances
    By stjohnsmythe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-13-2010, 06:53 AM
  6. creating multiple instances of excel
    By Sebastian1942 in forum Excel General
    Replies: 2
    Last Post: 05-02-2010, 02:08 PM
  7. macro for saving multiple instances of an xls in multiple formats.
    By tomotron in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2008, 12:01 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1