Great great Video. I saw this video after i saw another several PAD videos (harder) from your channel. I had to sart for this one. Many many problems i had before with Excel. Now i know how to fix the Excel Problems.. Thank you Anders Jensen. Obrigado.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Great video! What actions should I use when I want to refresh a data table in my Excel, copy the entire table and paste it on another sheet on the first empty row?
Thanks a lot, celenius. Let's split your problem. I would refresh an Excel table (that's what you want right) with a VBA script (invoked from PAD). For the rest I would just read from one sheet and write to the next (can also be done with VBA). You're more than welcome to post it at my Discord (link is in the description) with a screenshot. We'll gladly help you for free, but you have to start yourself. Have a great weekend. Kind regards, Anders
Thank you for sharing many useful articles about Power Automate Desktop!!! I have an Excel file (xlsm) containing VBA code, and I need to do the following steps: 1. Delete or hide the VBA code (convert to xlsx format?) 2. Restore the deleted or hidden VBA code from step 1. Is there any way to accomplish these steps? Thanks!
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Congratulations on the video. One question please. If I had a spreadsheet with several file paths, how could I update the variable with the Excel path that is declared at the beginning?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi! Thanks for your videos. Quick Question; what advantage (other than debugging) to use excel with Automate Desktop instead of just a normal "cloud flow" (AKA power automate)? Thanks in advance!
Hey Jason. Great question. If you isolate it: Not much. But in PAD you can use scripts, e.g. VBScript to automate Excel. If you want to do the same in PA, you need to utilize Office Scripts (which is limited to 1600 per day, not optimal for enterprise use). With PAD you can use an Excel file on any local or network drive, with PA it needs to be place in the cloud (e.g. SharePoint, OneDrive or Dropbox). I hope it helped a little. Kind regads, Anders
iam using local website in which i have to click a parent link containing child links which may vary in each parent link. So how can I loop through different number of child links of a parent link to scrape data. I used for loop in which starting point I put 1, and increment by 1, but I dont know end point. Experimentally i gave -1 in end point but PAD doesnt gave what I want.
Hey naresh kumar Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
Since last update of PAD the excel does not launch. I've already tried to solve by running aplication before launch excel as I tried to finish process. Do you have any other ideias to solve it?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
I want to use power automate desktop to fill a web page with the content of an excel table . First, I will have to match the beneficiary Id from both table then take each item of the Mother DoB column of the excel table then click on update on the web page and populate. Kindly provide me with step by step guide.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hey Mark. First you need to use a Get files in folder. Use *.xlsx as File filter. Then you can use a For each and itereate through each file name. Use the CurrentItem in the Launch Excel instead. Kind regards, Anders
Did the video help you?
- You can then help me by giving it a thumbs up 🙌❤
Thank you 😊
Wow that explanation was so clear and precise, I'll be watching more of your videos.
Appreciate the love, thanks, Itility 🙌😊
Great great Video. I saw this video after i saw another several PAD videos (harder) from your channel.
I had to sart for this one. Many many problems i had before with Excel. Now i know how to fix the Excel Problems..
Thank you Anders Jensen. Obrigado.
Hey Alvin, I'm so glad to hear, soon I will have new Power Automate Desktop videos going out 😊 Kind regards, Anders
I´ll be waiting for them. Thank you.
thank for your great videos @andersjensenorg! Can we copy data from excel's cell to somewhere on website?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi,
Great video!
Do you know maybe, how to open all excel from folder(or 1 by one) and rename excel file with cell C2 from each file?
Thank you
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Great video! What actions should I use when I want to refresh a data table in my Excel, copy the entire table and paste it on another sheet on the first empty row?
Thanks a lot, celenius. Let's split your problem. I would refresh an Excel table (that's what you want right) with a VBA script (invoked from PAD). For the rest I would just read from one sheet and write to the next (can also be done with VBA). You're more than welcome to post it at my Discord (link is in the description) with a screenshot. We'll gladly help you for free, but you have to start yourself. Have a great weekend. Kind regards, Anders
Thank you for sharing many useful articles about Power Automate Desktop!!!
I have an Excel file (xlsm) containing VBA code, and I need to do the following steps:
1. Delete or hide the VBA code (convert to xlsx format?)
2. Restore the deleted or hidden VBA code from step 1.
Is there any way to accomplish these steps?
Thanks!
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Congratulations on the video. One question please. If I had a spreadsheet with several file paths, how could I update the variable with the Excel path that is declared at the beginning?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
I found a solution After seeing your video.
I'm so glad to hear, thanks a lot 🤩 Kind regards, Anders
Hi! Thanks for your videos. Quick Question; what advantage (other than debugging) to use excel with Automate Desktop instead of just a normal "cloud flow" (AKA power automate)?
Thanks in advance!
Hey Jason. Great question. If you isolate it: Not much. But in PAD you can use scripts, e.g. VBScript to automate Excel. If you want to do the same in PA, you need to utilize Office Scripts (which is limited to 1600 per day, not optimal for enterprise use). With PAD you can use an Excel file on any local or network drive, with PA it needs to be place in the cloud (e.g. SharePoint, OneDrive or Dropbox). I hope it helped a little. Kind regads, Anders
iam using local website in which i have to click a parent link containing child links which may vary in each parent link. So how can I loop through different number of child links of a parent link to scrape data. I used for loop in which starting point I put 1, and increment by 1, but I dont know end point. Experimentally i gave -1 in end point but PAD doesnt gave what I want.
Hey naresh kumar Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
Since last update of PAD the excel does not launch. I've already tried to solve by running aplication before launch excel as I tried to finish process. Do you have any other ideias to solve it?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
I want to use power automate desktop to fill a web page with the content of an excel table . First, I will have to match the beneficiary Id from both table then take each item of the Mother DoB column of the excel table then click on update on the web page and populate. Kindly provide me with step by step guide.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
How can I apply a similar action to all of my excel files on a folder.
Hey Mark. First you need to use a Get files in folder. Use *.xlsx as File filter. Then you can use a For each and itereate through each file name. Use the CurrentItem in the Launch Excel instead. Kind regards, Anders