while running macro, work with another excel

[gok.nat]

Dear Team,
I am running a macro, it will take more time time to give result. In the mean time I wants to open another excel and wants to do some other work (donot want to sit idle till the result from macro). how to do this?
Can you please any one help me, that would be greatly appreciated.

Thanks in advance.

 

[lohithsriram]

Hi,

You need to create a new instance of Excel for this. Once your Macro is running on Excel, go to start, run and type in "Excel" to open a second instance. Open your other workbooks on the 2nd instance.