Flow - Macros need to open a txt file

(0) Share

Report

Posted on by Community Power Pla...

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

All responses (1)

Answers (0)

lbendlin 7,794 Super User 2025 Season 1 on at

Like (0)

Report

Re: Flow - Macros need to open a txt file

Are you planning to use PAD or a cloud flow?

Have you considered using Office scripts instead of macros?