
Announcements
Hi, please assist.
I have started with a flow where I launch Excel file.
Then I Run Excel macro.
This macros need to read in two text files, so it opens a window where it prompts me to click on the first text file. Once that is done, it will opens another windows, prompting me to open the second text file. what would be the next actions to allow flow to perform these automatically.
On a daily basis these text file names are different. It starts with and ends with the same characters for e.g dv05m0316d1.
However, the digits changes according to the previous day's date.
How would I make use of a variable in the filename?
Regards
Are you planning to use PAD or a cloud flow?
Have you considered using Office scripts instead of macros?