-1

I am trying to run a Macro between 3 workbooks through Power Automate. Since I launch the workbooks through Power Automate they are being run in 3 different instances(I dont know why). That is why Macro cant be applied between 3 different instances. Do you have any solution, idea about that? Would be pleased from your help. Thank you.

braX
  • 11,506
  • 5
  • 20
  • 33
Vbs.ak
  • 1
  • 1
  • [Why is "Can someone help me?" not an actual question](https://meta.stackoverflow.com/a/284237/8422953) – braX Feb 08 '22 at 22:04
  • Previously: https://stackoverflow.com/questions/30363748/having-multiple-excel-instances-launched-how-can-i-get-the-application-object-f "run a macro between 3 workbooks" is a bit unclear though. – Tim Williams Feb 08 '22 at 23:49
  • Are you meaning Power Automate Desktop? PowerAutomate can't run macros, it's not supported in Excel online so I figure you're meaning PAD. – Skin Feb 09 '22 at 11:14

1 Answers1

0

I think you could try opening one file from PAD and running a macro that will open the other 2 files.

Martin Tassara
  • 101
  • 4
  • Thank you for the answer Martin. I guess you mean Power Automate Desktop by PAD. Actually this is an alternative but through PAD it is not so accurate each time to perform this task because there are many inputs(mouse movements, clicks etc.) That is why primarily I need a fixed scripts like Macro. – Vbs.ak Mar 11 '22 at 14:11