Jump to content

SendKeys and Excel VBA


Recommended Posts

Hi

I am looking for examples of AutoIt using sendkeys.

What I would like to use is from an Excel VBA to call the AutoIt.exe file and then take a value from Excel (say cell D4 text  'abc') and sendkeys to an app (the only other open application). Could be Word, Notepad, Arduino monitor, etc. any and only 1 of which will be open.

Where would I find such examples ?

Link to comment
Share on other sites

Please have a look at the Excel UDF that comes with AutoIt to read Excel values. 

To send keys to an application check Send or Controlsend. 

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Please take also a look in VBA manuals / google regarding VBA and SENDKEYS as you can do your stuff like notepad most likely directly from VBA.

Otherwise I would suggest to write your whole solution in AutoIT and not mix VBA and AutoIT complicating your solution.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...