By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

How to run the Excel Macro in parallel

P: 2
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:\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
Range("D7").Select
ActiveCell.FormulaR1C1 = "50"

' Start to run the macro
Range("D8").Select
Application.Run "'norm ops 150607.xls'!Macro2"

' Save and close the spreadsheet
ActiveWorkbook.Save
ActiveWindow.Close




Workbooks.Open Filename:="C:\Documents and Settings\Administrator.SLB_EUROPE\Desktop\sachsend isruption6mths.xls"

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

' Change the number of iterations
Range("D7").Select
ActiveCell.FormulaR1C1 = "50"

' Start to run the macro
Range("D8").Select
Application.Run "'sachsendisruption6mths.xls'!Macro2"

' Save and close the spreadsheet
ActiveWorkbook.Save
ActiveWindow.Close


I would like to run 'norm ops 150607.xls'!Macro2' and "'sachsendisruption6mths.xls'!Macro2" in parallel.
Jun 25 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.