Unanswered

Set Excel as a Variable

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a flow that opens Excel using the control center due to add-ins so when it opens it is not a variable. I later need to reference the sheet for copy/paste, etc. How can I set it as a variable or reference the sheet/workbook? I am currently having the issue when trying to use get first free row and not being able to select the sheet.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Use "Attach to Excel" action after it is opened.

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Here is one possible solution for you:
1. Launch Excel
2. Set the worksheet
3. Get the first free row

Hope this will help you.

Regards
Kaif

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for your answer! I think this solution will work. I am receiving this error:
Are there any other steps that must accompany?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

It is supposed to accept the whole path, so it's odd that it is erroring out. But try just putting the name in the parameter: AFO WIP Weekly.xlsx

If that doesn't work, let me know.

Also, instead of Wait 15 seconds...try Wait for Window. Have the workbook open when you build this.

Find window: By title and/or class

Then press select window, hover over the workbook until you get a red box around the whole thing, and then Ctrl + Left Click to capture window info.

Wait for Window to: Open

Then have your attach function.

Good luck!

Was this reply helpful? Yes No