Thanks very Patel45. That works great now. Is it possible to add the following step too.


Say cell B4 in the original spreadsheet (where this macro is located) is the name of a macro in the newly opened spreadsheet. I need to run this macro and then copy data (say cell B5) from the original spread sheet into the newly opened spreadsheet (say into cell A1)

Hope that makes sense. Thanks again