AutoHotkey and Excel - AutoHotkey Tutorial #10

[@andersjensenorg]

Do you want the entire The Beginners Guide to AutoHotkey? Check this 83 min. video - kzbin.info/www/bejne/d6fdmZSled2XbrM

[@fmildemberger]

Every time I watch your videos I learn a little more..thank you

[@andersjensenorg]

Thanks a lot 😊👍 Kind regards, Anders

[@JoseFlores-ce7er]

Could you update this tutorial for AHK v2? Thank you in advance

[@GeorgeFromCy]

Andres thank you so much .. I was wondering whether we can copy a range of cells to another workbook if the range is pre typed into another workbook

[@andersjensenorg]

Hey George FromCy I worked within AutoHotkey for more than five years, but I started to find myself limited (I couldn't automate everything). As a result, I've changed the tool to UiPath. It's free as well; it's low code (drag-n-drop), the most used RPA tool in the world. Find my beginners guide here: kzbin.info/www/bejne/qaGYi6p8gMubY5I Kind regards, Anders

[@GeorgeFromCy]

@@andersjensenorg thank you so much for taking the time to reply. Much appreciated

[@rimantasdanilevicius6754]

Hi, Andres, Thanks for this video. Seems very simple explanation and every thing is working! Like always you cover almost everything in detail and very clearly. I have a question: while we looping though some values how to tell AHK thatI want to insert data in the new line. Loop though D column, find the last value and write/add/paste new value on the new line? In your example 7:58 I want to paste new value only in cell D6.

[@andersjensenorg]

Hey Rimantas. Thanks for all the great questions. We can get that very easily by just, because we know the value of the A_Index must hold the index of the last cell with something in. Then we can use the A_Index + 1 to get the first empty. Another method would be to count the rows with ex.activesheet.rows.count assign it to a variable and simply add +1 to it and then write it out with ex.Range("D" . index+1). Let me know, if that helped. Kind regards, Anders

[@rimantasdanilevicius6754]

@@andersjensenorg Hello Andres, thanks for your answer :) I am not sure if I using code right. I getting infinity loop with first example you mentioned index+1. I think while loop is not suitable in this situation. The second one I was not able to use because did not know how to write syntax. i tried: while(xlApp.Range("a" . A_Index).value !="") { xlApp.Range("a" . A_Index+1) := todayDateVar } But i found another code which works, but its possibilities limited, because I can insert only value in one column, but not multiple. this works for me: for cell in xlApp.columns(1).cells if !Cell.Value { Cell.Value := todayDateVar break }

[@UweKasner]

hi.great video. is there any way to make a digital signatur and save the sheet as an pdf via AHK?

[@andersjensenorg]

Hey Uwe Kasner I worked within AutoHotkey for more than five years, but I started to find myself limited (I couldn't automate everything). As a result, I've changed the tool to UiPath. It's free as well; it's low code (drag-n-drop), the most used RPA tool in the world. Find my beginners guide here: kzbin.info/www/bejne/qaGYi6p8gMubY5I Kind regards, Anders

[@kranthireddy519]

Hello Anders, In UiPath academy there is an example in EXCEL AND DATA TABLES - Practice 3(Calculating percentages of expenses). Can you please explain that!! Thank you

[@andersjensenorg]

Hey Kranthi. Check this video, kzbin.info/www/bejne/Y6jOqZ5_aLioi80 and let me know, if you have any specific questions afterwards 😊 Kind regards, Anders

[@fluffyhoneytina]

i need a hot key to fill in a cell yellow

[@andersjensenorg]

Hey Honey Tina I worked within AutoHotkey for more than five years, but I started to find myself limited (I couldn't automate everything). As a result, I've changed the tool to UiPath. It's free as well; it's low code (drag-n-drop), the most used RPA tool in the world. Find my beginners guide here: kzbin.info/www/bejne/qaGYi6p8gMubY5I Kind regards, Anders

[@fluffyhoneytina]

@@andersjensenorg COOL AND THANKS.

[@shefsali2662]

Please what version of autohotkey is 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 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

[@antoniong4380]

I've got an 0x80010001 Error, saying that the call/request was rejected by the target. And also adds that specifically the Ex.Range...'s 'Range' rejected it

[@andersjensenorg]

Hey Antonio. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@meenaxavier3575]

Xpath XDOM path we need tutorial about that in automation anywhere

[@andersjensenorg]

Hey Mercury. At the moment I don't have time for AA 😔 Kind regards, Anders

[@meenaxavier3575]

@@andersjensenorg hi sir, It's ok sir Thank you so much for your reply 😊

[@jasoncupak4211]

I don't have any AutoHotKey script in my "New" menu

[@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

[@apocalypticbean]

Where can I find the AHK syntax to work with Excel? I mean like the documentation. Nice video BTW

[@andersjensenorg]

Hey Dum Dum. Thank you 🙂 I doubt it really exists, hence I made the video. And you are right, I could have done a lot more, so see it as an introduction. Have you thought about taking a look at UiPath? It's totally free for private use and can do a LOT more: kzbin.info/www/bejne/aYuuq4d-mdWmitU Kind regards, Anders

[@BoredErica]

This is Excel only, right? It doesn't work for Google Sheets in a browser?

[@andersjensenorg]

Hey BoredErica. That's right, but have you seen Microsoft Power Automate Desktop: kzbin.info/www/bejne/sIfZkoV5j9aNbac Kind regards, Anders

[@krishnagajera4631]

I am getting an error when I try to replicate the code "Error: 0x800401F3 - Invalid class string". Do you have any idea about this how can I fix it?

[@andersjensenorg]

Hey Krishna. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@DeepThinker193]

Cant see anything, this is with a friggen 55 inch monitor. Cant get the code to work very frustrating

[@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 4900+ 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

[@shonilcha]

Looks like this is a repeat from an earlier video of yours?

[@andersjensenorg]

Hey Leo. True, it is from here: kzbin.info/www/bejne/d6fdmZSled2XbrM The plan with this playlist is that I can update it dynamically, e.g. when I want to make a better video of one of the topics. Kind regards, Anders

[@ingewll]

I can't read your code. To small

[@andersjensenorg]

Hey Inge. Can you try to change the resolution of the KZbin player to 1080p? And then maximize the screen. Kind regards, Anders

[@ingewll]

@@andersjensenorg I have done that but it does not help enought.

[@ingewll]

Compare yours against The Office Lab, Automated Control Chart in Excel and see for yourself

[@andersjensenorg]

Send me your email on [e-mail] and I share the original video with you 🙂

[@andersjensenorg]

Hey Inge, I have just sended you a mail with the original video (OneDrive link). Kind regards, Anders

[@sciences-sci]

To smal, write in greate window

[@andersjensenorg]

Hey Rachid. Sorry and I agree. In my newest videos I zoom in on the code. Kind regards, Anders

[@laigrimmie6610]

hi sir can you help make my own ahk script in the game i play... where can i contact you

[@andersjensenorg]

Hey Lai Grimmie I worked within AutoHotkey for more than five years, but I started to find myself limited (I couldn't automate everything). As a result, I've changed the tool to UiPath. It's free as well; it's low code (drag-n-drop), the most used RPA tool in the world. Find my beginners guide here: kzbin.info/www/bejne/qaGYi6p8gMubY5I Kind regards, Anders