Answered

Save Print Output As Dialog Box - Unable to Spy

(0) Share

Report

Posted on by Neha2904

I have an external excel macro that has a button control which opens a "Save Print Output As" dialog box on click.

Once this popup appears control works except the "Save Print Output As" foreground window. At times , there are more than one "Save Print Output As" window.

Now, desktop automation is not working as I cannot identify the control. So I tried using title and class properties and send keys later but it does not work as well.

Is there any script or other way to wait for popup and then save file.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

MichaelAnnis 5,727 Moderator on at

Like (0)

Report

Is the macro done when the Save As window opens?

Was this reply helpful? Yes No
Neha2904 94 on at

Like (0)

Report

Yes.
The catch is that there is a button to be clicked. If I run the macro behind it, the macro will keep running till someone fills in the Save as dialog.
So, I used UI Automation to identify and click on the button that initiates the macro and generates the "Save as" popup that needs to be populated.

Was this reply helpful? Yes No
Neha2904 94 on at

Like (0)

Report

It is not able to identify window if there are more than one window with same title "Save Print Output as". Works fine with single popup window.

Was this reply helpful? Yes No
Verified answer

MichaelAnnis 5,727 Moderator on at

Like (0)

Report

Okay good; that's what I was concerned about - that you were using UIs to initiate so it wasn't locked out. In that case, does the proper save as window always open with focus, because if so, then instead of using Wait for Window to Open, I would pick an element on the window, so Wait for windows element "filename" to exist in focused window. That way, if there is another SaveAs window open in the background, it won't matter. This new one will come into focus and it will move on when it sees that element.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Hi @Neha2904

Could you help me clarify a bit about the windows? There is a mention about a "Save as" window which is to save a file. And also you have mentioned about "Save Print Output As" window which is to print a file. Hope you are giving the right window titles.

I didn't fully understand the requirement but if you just want to trigger the Print save as window can you do a Send Keys of Ctrl P on the Excel to bring up the Save Print Output as window in the foreground?

Was this reply helpful? Yes No
Neha2904 94 on at

Like (0)

Report

The problem is if I try to record or identify the UI element, it does not work as once the popup appears, it becomes the foreground window and doesn't allow PAD to interact with it. Hence, I had to go for "Wait for Window" with class and title.

Was this reply helpful? Yes No
Neha2904 94 on at

Like (0)

Report

Yes, the window is titled "Save Print Output As" and I am using the same. It is to print the file. Will correct the question.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Alright, and also try the sendkeys alternative I have shared to bring up the Print box.

Was this reply helpful? Yes No