Open any excel in folder and edit it

(0) Share

Report

Posted on by Ishaq

Hi,

I am using power automate desktop, and I need to do the fallowing:

To find the excel file in folder and open it, with note the excel file name is not fix, it's change so I need power automate to find the excel and open it regardless the name.

Other point I need power automate desktop in excel to copy a cell with formula and past only the value in different cell.

Can you please advise me?

Thank you

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Try this:
1. 'Get files in folder': input the folder where excel is and File filter = *.xlsx. This will give you %Files% as variable produced
2. 'Launch Excel': Launch Excel and open the following document, Document Path = %Files[0]%. This gives %ExcelInstance% as variable produced
To copy and paste:
3. 'Read from Excel worksheet': Excel instance = %ExcelInstance%, retrieve = The value of a single cell. Input row and column coordinates. %ExcelData% as variable produced
4. 'Write to Excel worksheet': Excel instance = %ExcelInstance%, Value to write = %ExcelData%, Write mode = On specified cell. Define coordinates of cell you want to paste

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for this. I was able to get the automation running but it only opens and edits the first file in the folder. How do I get it to repeat the action for all files in that folder?

Was this reply helpful? Yes No
mktranslation 32 on at

Like
a
(0)

Report
Copy link

Link copied!

You need to use Loop function. Namely, For Each, and use %Files[0]% as CurrentItem..

Was this reply helpful? Yes No