👍 teaching appreciated!! Got stuck with AppActivate claiming invalid procedure call ect.. any idea why? It happened when you wanted to call back the calculator for 2nd calcuation.
Are SendKeys and AppActivate subroutines which is why you are calling them using 'Call' while waitTime is a function and doesn't require the 'Call' syntax?
Hey Matt, Great work with teaching us so much. I was trying to create a macro which on clicking any command_button would take a screenshot, open word and paste it there. I have been able to code the part of opening a word doc, However, i am not being able to simulate the pressing of the PrtScrn and Ctrl+V. ( i used sendkeys for this, but it's still not working ) Could you please let me know how i can get this done?
There about a 50% chance when calling the notepad that it opens behind the calculator, and herby just copies the result back into the calculator. Occurs when a calculator is already open. I'm confused about this randomness.
Thank you please I have a question about a program for archiving and PDF documents in Excel and work Hyperlink and stores incoming and outgoing taken Skinner please
I have just taken about a year off due to the birth of my beautiful baby daughter :) I have a meeting booked next week with a colleague of mine to discuss relaunching content from April so subscribe and watch this space :)
Is SendKeys good? It is stated that it "emulates" keyboard clicks. But this is complete nonsense !!! From the keyboard, I will press the "1" number twice and the number 11 will be entered, And through sendkeys press any number of times, and only the number "1" will be entered, replacing all previous ones Well, what the hell is "emulation of clicks".
you can get it to send the 11, play around with it and see. Whether it is good or not is open to debate. I would recommend against any form of business automation with it since it only takes one thing to go wrong and suddenly it is clicking/typing all over the place. But for personal use it can help speed some things up. Overall I would say its more of a gimic than actual "good"
@@YourprogrammingnetworkCoUk I mean AHK is free and can be ran off a USB, provided the admin gives you permission to run your own executives. Unfortunately thats why im here. Our IT guy thinks freeware is a security threat but has never heard of a macro-virus.
@@carlosguzman3085 Run, Calc.exe WinWaitActive, ahk_class CalcFrame Send, 63 return Whats so complicated? You also dont need to run any host applications like Excel to use your AHK scripts.
Came to work. Whole day had writing sendkeys. At the end of it pressed F5 and made everything in one moment.😁
That's our goal!😎
Congratulations! I've been watching your videos since "Excel 2003 VBA" tutorials. Keep up with the great work!
Cheers :) the 2003 ones seem so long ago now!
Great channel! I got here what I have been looking a couple days with no luck, thank you! :D
👍 teaching appreciated!! Got stuck with AppActivate claiming invalid procedure call ect.. any idea why? It happened when you wanted to call back the calculator for 2nd calcuation.
Call AppActivate(CalcID, False) is erroring out, can you please help....
Are SendKeys and AppActivate subroutines which is why you are calling them using 'Call' while waitTime is a function and doesn't require the 'Call' syntax?
I've been looking for this. Weeks. thank you so much.
Superb. Excellent explanation. Very helpful. Thanks.
Great video! But I am using excel 2019 and met with "Invalid procedure call or argument (Error 5)" when running the codes. Please help. Thanks!
Hey Matt, Great work with teaching us so much.
I was trying to create a macro which on clicking any command_button would take a screenshot, open word and paste it there.
I have been able to code the part of opening a word doc, However, i am not being able to simulate the pressing of the PrtScrn and Ctrl+V. ( i used sendkeys for this, but it's still not working )
Could you please let me know how i can get this done?
Can we use these hot keys when we are automating internet Explorer..
Are VBA can do send key for non-Microsoft program such as Oracle Accounting System?
Thank you for this video, Sir is it possible to get the filter menu in a excel sheet using sendkeys function(Alt +Downarrow).Thank you in advance.
Hi, i need to pass the TAB key to 3rd party application is there any way, please help
good lesson thank you
Thanks Matt for all your help! Do you know how to take the square root with the Microsoft Calculator in VBA, thanks?
+Mathew Fok ,
ActiveCell.Value = Cells(x, y).Value ^ (1 / 2)
There about a 50% chance when calling the notepad that it opens behind the calculator, and herby just copies the result back into the calculator. Occurs when a calculator is already open.
I'm confused about this randomness.
nice video and great work but i face one problem i need to use mouse too...because my software need to click on some options
Thank you please I have a question about a program for archiving and PDF documents in Excel and work Hyperlink and stores incoming and outgoing taken Skinner please
Thanks so much for this.
How to send spacebar key..I want to tick one radio button
Great work! Thanks very much
How attach file if windows explorer opened ?
great series, after i use sendkey code numlock button is deactivated. i dont know why? (i use excel 2010)
thomas fergusen yeh that’s a strange one not heard of that happening before 🤷♂️
Are you still active on this channel??
I have just taken about a year off due to the birth of my beautiful baby daughter :) I have a meeting booked next week with a colleague of mine to discuss relaunching content from April so subscribe and watch this space :)
Superb 👍👍👍
Is SendKeys good? It is stated that it "emulates" keyboard clicks. But this is complete nonsense !!!
From the keyboard, I will press the "1" number twice and the number 11 will be entered,
And through sendkeys press any number of times, and only the number "1" will be entered, replacing all previous ones
Well, what the hell is "emulation of clicks".
you can get it to send the 11, play around with it and see. Whether it is good or not is open to debate. I would recommend against any form of business automation with it since it only takes one thing to go wrong and suddenly it is clicking/typing all over the place. But for personal use it can help speed some things up. Overall I would say its more of a gimic than actual "good"
good one dude
Proof that anything VBA can do AutoHotKey can do better and easier
most corporate environments have excel and not autohotkey available so its not always about which one you think is best.
@@YourprogrammingnetworkCoUk I mean AHK is free and can be ran off a USB, provided the admin gives you permission to run your own executives. Unfortunately thats why im here. Our IT guy thinks freeware is a security threat but has never heard of a macro-virus.
@@pinkhead6857890 so much work bro, the other way is more simple...
@@carlosguzman3085
Run, Calc.exe
WinWaitActive, ahk_class CalcFrame
Send, 63
return
Whats so complicated?
You also dont need to run any host applications like Excel to use your AHK scripts.
Sir in my case the below function is not working .Please help .
all the time showing expected list separator )