Answered

Excel - Launch ' Make Instance Invisible"

(0) Share

Report

Posted on by TTC Super User 2024 Season 1

The process starts by opening an Excel file however, a problem occurs when I try to make the entire process invisible. I would prefer not to see each cell being filled in Excel or each Excel open on my screen. When I deselect the "make the instance visible" option within the "launch Excel" action, the Excel file appears to be completed within in the flow. If I attempt to open the resulting Excel file, the sheet is hidden and the Excel is not open anywhere, but it shows it's open or sometime if it allows me to open it, I got a totally black screen. So, the flow force me to keep the Excel Launch as 'Visible' that way I can open the result file. Any suggestions would be appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (18)

Answers (1)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@TTC

Have you tried with different excel file and all excel having same issues?
In the meantime, Try to terminate the excel before launch the excel file and after saving the excel file and see whether that resolves your issue. Please refer the below approach:

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
TTC Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Deenuji

I try your method and it did not work. Yes, that happen to every single result file.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@TTC

Unable to replicate the issue, but you might want to consider adopting this approach once:
Instead of saving your Excel file during the excel closure, utilize the "Save Excel" action to save your excel(screenshot attached) and close your excel file(dont save excel in this step).

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
TTC Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Deenuji

Thank you for all your suggestions. However I conclude the problem is an Excel. The PAD won't let me view the result file through excel. I make one of the file save as .csv and I was able to open and see the result data as .csv format. But I have tried both the excel extension and it won't let me view the result data in Excel.

Let me know if you have anymore idea. It looks like there's a bug between PAD and Excel. I may spot some other folks have the same situation in the forum.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@TTC

Could you kindly verify the functionality by running the same flow on a different virtual machine? Confirm if the excel changes looks good on the new system. If it does, the issue may lie with the on-premises Excel software in your previous system.

Alternatively, if you encounter a similar problem on another machine, consider adjusting your PAD by upgrading and downgrading to assess whether these modifications resolve the issue.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
TTC Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yea, this is dead in the water. I install the PAD on my second machine and try to run the same flow and I don't have permission to login to the mailbox in the server for me to grab the email attachment file. And IT won't give another permission for my second PC which is a different profile. It stops me when I try to connect to the exchange server.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@TTC

First copy all the code from PAD using ctrl+A and paste into text file and follow the gif.

or follow the below linkedin post:
LinkedIn post for transfer the flow

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
TTC Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I don't have to do that. Once I login to PAD on the another machine it brought all my flows.

The problem it stops me from login into the server from the other machine.

Was this reply helpful? Yes No
TTC Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Any more suggestions or PAD is not compatible with MS Office 21

Was this reply helpful? Yes No
TTC Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I also tried to save the result of the Excel file on my local drive and I got the same result. Blank excel file. I am sure you or someone might have a different idea or workaround through PAD.

Was this reply helpful? Yes No