0

I currently have several Excel VBA macros that open the desktop Outlook application, download specific files from received emails in certain email accounts, perform operations, and send an email back.

I would like to improve this process by scheduling these macros to run automatically using Power Automate. The Power Automate flow should also download some Excel files from a website before running the macro.

From my research, I understand that I would need to acquire a Power Automate Premium license to schedule the execution of these flows through the Windows Task Scheduler. However, my problem is that I would like to be able to run these flows without the need for the Windows session to be logged in. From what I've read and tested, it seems that Excel macros cannot be executed without the Windows session being logged in.

Is there a solution for this issue with Powe Automate Premium? Do I need a Power Automate Process license to execute flows in unattended mode? Will macros that interact with desktop applications work in this mode?

Thanks in advance. Best regards.

Improve this question
5
  • When you tested it, was the Run whether user is logged on or not option selected ?
    – CDP1802
    Commented Mar 3 at 19:44
  • You can likely just use Task Scheduler and convert the "download some Excel files" part into VBA - no new license required. It does need to run under a user account, though you can have Task Scheduler use an account for its run, without needing to leave that account logged in the whole time....
    – Tim Williams
    Commented Mar 3 at 20:00
  • I’d be switching to Office Scripts and PowerrAutomate cloud flows if you can. Probably too hard but would be a lot more robust.
    – Skin
    Commented Mar 3 at 20:11
  • Yes, I have selected the option "Run whether user is logged on or not" and they don't work. Have you been able to run an Excel macro from the Task Scheduler with the Windows session logged off? Everywhere I have searched for a solution I have read that It is not possible.
    – user29874344
    Commented Mar 3 at 21:35
  • Do you have PowerShell ? Type powershell -? in a cmd window
    – CDP1802
    Commented Mar 5 at 16:52
Related questions
2187
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
648
How can I avoid using Select in Excel VBA?
1
A question about Power Automate to proceed macro from another excel file
Load 4 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.