Excel & DataTables in Power Automate Desktop - Including VBA and VBScript

[@andersjensenorg]

Thanks for all your likes and support 🙌🔥 You should watch this video next: kzbin.info/www/bejne/kKfFn6iHpZyra8k

[@andersjensenorg]

@@PowerAutomateDesktop0322 Sure, you can use the Run desktop flow action with input/output variables 🙂 Kind regards, Anders

[@budgetappliancespares9411]

You are an exceptionally talented teacher and for someone not English, you speak better English than the English themselves. I love you man!!! Have learnt loads from you.

[@andersjensenorg]

Haha, thanks a lot, my friend 😍😍😍 I have many more PAD videos to come during the next months. Have you seen my new PL-500 course (only the first lesson so far): kzbin.info/aero/PLXXz88_TPiHrnu0itj7At0K-xEZyl2XNr Kind regards, Anders

[@jmathew6988]

Dear Anders, I started watching your videos on Power Automate since about 2 weeks ago, starting with the beginner's tutorial. I want to say that all of them are wonderfully explained, making the learning experience really enjoyable and easy to understand. I am new to this application, but by now I have successfully created some very helpful automate flows for my work. I want to dedicate a big salute to you and wish to thank you for all the help so far. 🙏

[@andersjensenorg]

Appreciate the love, thanks a ton, j 🥳😍 These comments make it easy to find the motivation to create more videos. Please let me know, if you see something I can do better. Kind regards, Anders

[@jose00033]

I’m all here for this! Thanks Anders! Keep sharing the knowledge

[@andersjensenorg]

Hey Jose Carlos! Thanks a ton for the nice message, highly appreciated. Have a great weekend ☀🙂 Kind regards, Anders

[@yahyafares7515]

Thanks again Anders for this amazing tutorial. keep going and thank you for sharing best practices in Power Automate desktop

[@andersjensenorg]

Hey @yahyafares7515. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@DIY-Investors]

Another extremely useful video… thank you Anders. My rate of knowledge growth (in PAD) is rapid, thanks to your guidance and very clear tutorials! Best wishes, Mick.

[@andersjensenorg]

Hey Mick, thanks a bunch for the kind words 💪🙂

[@tonberryking3368]

4:20 You can end the hanging excel process by ending the open excel task in task manager > details. Always a good place to look if an automated file isn’t opening

[@andersjensenorg]

Thanks a lot, tonberryking. I prefer either cmd/PowerShell because it can also be implemented in PAD. Have a great day. Kind regards, Anders

[@APPALARAJUYADLA-dy5hv]

Great Video Jensen

[@andersjensenorg]

Many thanks 😍🦾

[@davidjosevarelagarcia7011]

Hello Jensen, great video and contribution to the community. A question, I did the exercise and I understand only that the part when the excel file is saved and I add the formatted date sends me an error but if I leave only the name of the new file there if it is saved, any suggestions, I would greatly appreciate it. sds

[@andersjensenorg]

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 13,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@stineandtherobots]

I love the intro (and automation) 😍🤖

[@andersjensenorg]

Haha, thank you 😍

[@NgNg-zg9zm]

Hi Jensen, I have been learning Power Automate Desktop by watching your video. Thanks a lot for bringing such meaningful knowledge in the easiest method for beginners. I am applying power automate desktop into my daily task. I would appreciate if you could help to guide me how to launch the latest excel file. For example, 16 Sept is Monday, and I would like to open the file of the last working day (Friday), instead of Sunday. Thank you

[@andersjensenorg]

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 13,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@entertainmentgalaxy971]

hi thanks for another amazing video, i have a question, why did you add insert column F which i think dont need to add as there is no column after E.

[@andersjensenorg]

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 11,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ALVINMAN452]

Thank you for the video. Do you have any course about VBScript?

[@andersjensenorg]

Unfortunately not anything else than in this video, but I can recommend ChatGPT (even the free version GPT 3.5). Kind regards, Anders

[@ALVINMAN452]

@@andersjensenorg Once more time thank you for the tip. Best regards.

[@Pipiziu]

Regarding the vbscript, I was having error Unterminated string constant for "%ActiveSheet%" where it used to reference the worksheet name. but where I use "Products" , it works. how to resolve this so it can reference the variable instead of the name of the worksheet .

[@andersjensenorg]

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 10,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@faheemworld_S]

Hi Anders How can I remove blank Rows from a data table?

[@andersjensenorg]

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 11,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@jimmyfal]

When I download the Candy.xlsx sheet the first 2 columns data are not in decimal format. For example: Cost says: 365, Price says: 694, Units Sold says: 315. However on your video is shows decimals. Am I doing something wrong? Or is your data not formatted correctly on your course files site?

[@andersjensenorg]

Thanks a bunch, @jimmyfal 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: kzbin.info/www/bejne/roipq2CJbpuLfdE You're more than welcome. Kind regards, Anders

[@KhatKhati-ok8rw]

Hello, I encountered a problem in converting text to number and it gives the following error. How do I fix it? Can't convert text '0/78' into a valid number (text provided is either in a non- recognizable format or contains too many characters).

[@andersjensenorg]

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 13,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@KaushikMHegde]

When I Read from excel worksheet... there is no data table that is showing up... Can someone help me with this?

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders