Run macros from Power Automate Desktop | Excel Off The Grid

แชร์
ฝัง
  • เผยแพร่เมื่อ 15 มิ.ย. 2024
  • ★ Want to automate Excel? Check out our training academy ★
    exceloffthegrid.com/academy
    ★ Check out the blog post & download the example file★
    exceloffthegrid.com/excel-mac...
    ★ About this video ★
    Power Automate Desktop is a Microsoft tool for automating processes in a desktop environment. It's a really powerful tool, but suffers from one significant drawback... it has limited Excel actions. However, Microsoft has given us the ability to run Excel macros from Power Automate Desktop; therefore, this gives us the power to do almost anything we like with Excel.
    So, that's what we are looking at in this post; how to run Excel macros from Power Automate Desktop.
    0:00 Introduction
    0:44 Example File
    1:36 Getting started with Power Automate Desktop
    2:57 Building a flow to run macros
    6:19 Running macros with arguments
    08:00 Conclusion
    ★ Download 30 most useful Excel VBA Macros ebook for FREE ★
    exceloffthegrid.com/
    ★ Where to find Excel Off The Grid ★
    Blog: exceloffthegrid.com
    Twitter: / exceloffthegrid
    #MsExcel

ความคิดเห็น • 18

  • @IvanCortinas_ES
    @IvanCortinas_ES ปีที่แล้ว +5

    Great video that perfectly answers how to proceed with macro-files-Excel within Power Automate. Very good explanation. Thanks Mark.

  • @CP-zb3ky
    @CP-zb3ky ปีที่แล้ว +2

    I didn't realize you can build in a macro to open another Excel workbook, this is a game changer!

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  ปีที่แล้ว +1

      Once the workbook is open, you can even run the macros in that workbook. 🤯

  • @Trucpq
    @Trucpq 5 หลายเดือนก่อน +1

    Interesting ! Thanks a lot

  • @ahmed19imran
    @ahmed19imran 11 หลายเดือนก่อน +1

    Thanks!

  • @Bashir_Kano
    @Bashir_Kano ปีที่แล้ว +1

    Thanks Mark. Your automation solution is top-notch. I wonder if you still have a solution to my payment problem. Your academy is all I need to be enrolled.

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  ปีที่แล้ว +3

      We only offer pricing in USD at the moment. We’ve got multi-currency options on our long term roadmap, but it’s unlikely to be this year.
      We are planning a promotion in late May, so check that out. It might make the pricing more affordable, even though it will still be in USD.

  • @RonDavidowicz
    @RonDavidowicz ปีที่แล้ว +1

    Hi Mark. Another great video.
    Have you found a way to have this type of flow run automatically on a schedule that doesn’t involve Power Automate on the web?

    • @McIlravyInc
      @McIlravyInc ปีที่แล้ว

      Wish that worked without a premium connector :( if you find something please share!

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  ปีที่แล้ว +2

      Check this out :th-cam.com/video/pFZSajbQsxc/w-d-xo.html
      Everything I know about Power Automate Desktop is based on Anders Jensen's YT channel, so well worth subscribing.

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  ปีที่แล้ว

      Check this out :th-cam.com/video/pFZSajbQsxc/w-d-xo.html

  • @elhadjimalickcisse7023
    @elhadjimalickcisse7023 หลายเดือนก่อน +1

    hello How you integrated the action into the Power Automation Cloud

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  29 วันที่ผ่านมา

      You need Power Automate premium licence. Then you can trigger Desktop from cloud.

  • @n9c581
    @n9c581 5 หลายเดือนก่อน

    In case macro Run-time error, flow dont run to next action, How to fix it?

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  4 หลายเดือนก่อน

      Apply error handling in the macro so the code completes how you want it to.