User Profile

Collapse

Profile Sidebar

Collapse
modularmix
modularmix
Last Activity: Jun 26 '07, 08:35 AM
Joined: Jun 25 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • modularmix
    started a topic How to run the Excel Macros in parallel

    How to run the Excel Macros in parallel

    Does anyone know the code for running the Excel Macro for two different spreadsheets in parallel. Here is the code that works for them sequentially.
    Code:
    Workbooks.Open Filename:="C:\Documents and Settings\Administrator.SLB_EUROPE\Desktop\norm ops 150607.xls"
    
    ' Select Asset & Portfolio Parameter sheet
    Sheets("Asset & Portfolio Parameter").Select
    
    ' Change the number of iterations
    ...
    See more | Go to post

  • modularmix
    started a topic How to run the Excel Macro in parallel

    How to run the Excel Macro in parallel

    Does anyone know how to run the Excel Macro for two different spreadsheets in parallel. Here is the code that works sequentially.


    Workbooks.Open Filename:="C:\D ocuments and Settings\Admini strator.SLB_EUR OPE\Desktop\nor m ops 150607.xls"

    ' Select Asset & Portfolio Parameter sheet
    Sheets("Asset & Portfolio Parameter").Sel ect

    ' Change the number of iterations
    ...
    See more | Go to post
No activity results to display
Show More
Working...