@ German Duterte, This series of videos are so much helpful. If i saw these videos before i think my vba programming was improved greatly & i could do much more things.
This is one of the better learn VBA API play lists that I have come across. Unfortunateely it didn’t come up so often in a search, but I am glad I found it eventually. Alan
We can also do some useful things IN Excel with API, such as navigating down a Pane window’s hierarchy to get to a button and then press it, which can give us a way to do something that their are no other known ways to do in VBA
Great video Alex Wrote my first API code. Sort of the API version of "Hello World". The tip on using API view was vary helpful. my first step to understanding API Thanks! for other API newbies like me watch the once before you try writing the code. You need to declare the WM_Close as a constant as well.
I find WinSpy++ a nice lightweight portable alternative. YT won’t let me give you a link, but if you google something like winspy Catch 22 you should get a few sources for it Alan
I tried to answer this, but YT keeps deleting it. Maybe they don’t like re directions anywhere in any form, or the post was too long. I will try in a reply below, that sometimes helps
Hi Alex, Thanks for the tutorials. I'm working on SAP Web Gui for HTML (Netweaver) for automation. So is it possible to automate the SAP (Netweaver) using the same approach. Please guide. Thanks Again, Prabir
I have a vba code by which I open the plink for ssh connection using shell command where I can run any command by StdIn.Writeline function except password change command. if I run a change password command I am unable to input the password by StdIn.Writeline function. The command is like "set usr pwd" this command gets executed perfectly and after it executes it asks for "Enter Current Password" here the writeline function fails to input the password. If you can point me to the right direction I would really appreciated your help.
Hi Alex I need a macro which save my print to PDF but the print command is already open in background I want to save that as PDF that I already had PDF converter in my printer list I just want to save the same in PDF for a specific location with name collect from excel cell like A3 name is manish so the PDF save as manish.pdf
Its useless tutorial very Irrelevant and not strait to the description
German Ochea lmao, you're right! i'm just gonna delete everything, this is garbage!
:))
@ German Duterte, This series of videos are so much helpful. If i saw these videos before i think my vba programming was improved greatly & i could do much more things.
This is one of the better learn VBA API play lists that I have come across. Unfortunateely it didn’t come up so often in a search, but I am glad I found it eventually.
Alan
We can also do some useful things IN Excel with API, such as navigating down a Pane window’s hierarchy to get to a button and then press it, which can give us a way to do something that their are no other known ways to do in VBA
Why I didn't find this 3 years ago... wow! This is great work of yours!
Great work Alex, straight to the point and easy to understand. 👍
Great video Alex Wrote my first API code. Sort of the API version of "Hello World".
The tip on using API view was vary helpful. my first step to understanding API Thanks!
for other API newbies like me watch the once before you try writing the code. You need to declare the WM_Close as a constant as well.
Thank you, the api viewer will be so useful
Could anyone Share the Public Delcare PtrSafe Functions?
Some are far to long and i can't download the software on work-laptop
You have got a great video and I hope that I find a solution for a problem I encounter at work.
Hi Alex, please could share the worksheet with all the function declarations? Many Thanks
thanks for the video. but can u please share all the declarations in ur module. or paste them in the video's description?
Awesome, thanks Alex.
Hi Alex, the best tutorial for beginners! Awesome. Question if we dont have spy++ in the office. Do we have a default application that we can use.?
I find WinSpy++ a nice lightweight portable alternative. YT won’t let me give you a link, but if you google something like winspy Catch 22 you should get a few sources for it
Alan
I tried to answer this, but YT keeps deleting it. Maybe they don’t like re directions anywhere in any form, or the post was too long. I will try in a reply below, that sometimes helps
didn't work sorry, YT have a strange AI bot thing here
Many Thanks Alex !!! Excelent
I love this stuff :)
Hi. Did you have to import all of the declarations that are in your module manually or is there a quick way?
Hi Alex, is it possible to share the file? Thank you so much
Interessante Man!
Hi Alex, Thanks for the tutorials. I'm working on SAP Web Gui for HTML (Netweaver) for automation. So is it possible to automate the SAP (Netweaver) using the same approach. Please guide.
Thanks Again,
Prabir
I have a vba code by which I open the plink for ssh connection using shell command where I can run any command by StdIn.Writeline function except password change command. if I run a change password command I am unable to input the password by StdIn.Writeline function. The command is like "set usr pwd" this command gets executed perfectly and after it executes it asks for "Enter Current Password" here the writeline function fails to input the password. If you can point me to the right direction I would really appreciated your help.
can you share alex module?
can you share the macro please? you are calling "sendmessage" but i dont see it here..
got it but the macro would be helpful :)
Hi Alex
I need a macro which save my print to PDF but the print command is already open in background
I want to save that as PDF that I already had PDF converter in my printer list I just want to save the same in PDF for a specific location with name collect from excel cell like A3 name is manish so the PDF save as manish.pdf