Power Platform Community Forum Thread Details

Hi Experts

I'm using the following flow to start excel and run my morning macro. It works fine.

Yesterday I encountered a situation where I was working and date changed so I needed to run the macro. Being experimental brain, I used PA to do the same.

This time, it opened a new incidence of the same file, there by one incidence became read only and other it worked with. With two incidents of same file, it there by gave an error in running the macro, as it needed to save the file too.

So, is there any way to tell excel, if the file is open, use that only than opening all over again.

The flow I'm using is as below.

Thanks in advance.

Much appreciated.

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Sanja\\Dropbox\\All Records.xlsb''' Visible: True ReadOnly: False Instance=> R01
Excel.RunMacro Instance: R01 Macro: $'''\'All Records.xlsb\'!BanksSortMorning'''

Categories:

Building flows