• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to use Autohotkey Command in Excel Vba?

C

Chirag R Raval

Member
Dear Sir,

Just require proper method's Example How to use Autohotkey Command
in Excel Vba ...

like VBA force to run auto hotkey command after find in cell some value or text....

or Vba wait till Input box fill-up by user to provide some key features which require for complete macro ...

Or If if VBA found cell value "This" then Run proper Autohotkey command ..

like an example we have 200 Buyer Numbers
...in macro ..search for just Buyer no & force to run auto hotkey command to
fill-up other data in sheet Via auto hotkey so there are no need to support
any extra excel file to for that...etc...


if Auto hotkey & Excel VBA combine work.. there are more possibility of automation
via Excel VBA..

hope- you co-operation

Regards,

Chirag Raval
 
Dear Sir,

I attached File .Please convert its extensions from .txt to .ahk & run it..
(It an Autohotkey script)

if anywhere we click ....writing cursor blinking & we write 11345 & give "-" sign quickly insert text M/s. SENATOR, AHMEDABAD,(11345)...

if in excel one cell have this number only "11345" how to run this script for
insert "-" so automatic convert that number in M/s. SENATOR, AHMEDABAD,(11345) ??

can anyone help for vba scipt for run this ?/

Regards,
Chirag Raval
 

Attachments

  • hotstring.txt
    373 bytes · Views: 12
Dear Sir,

I attached File .Please convert its extensions from .txt to .ahk & run it..
(It an Autohotkey script)

if anywhere we click ....writing cursor blinking & we write 11345 & give "-" sign quickly insert text M/s. SENATOR, AHMEDABAD,(11345)...

if in excel one cell have this number only "11345" how to run this script for
insert "-" so automatic convert that number in M/s. SENATOR, AHMEDABAD,(11345) ??

can anyone help for vba scipt for run this ?/

Regards,
Chirag Raval
 
Hi !

So nothing to do with AutoHotkey ?!
As it's just a simple worksheet event Change to link with a table (VLookup) …

For an AutoHotkey question, see on an appropriate forum.
​
 
Dear sir MarcL..

Thanks for your reply...but problem is my code
Generate many files each generated new file have
Buyer number in column "A" start from Row 2 (same number till its records end)
Now just want to insert 1 blank line above headinds
& in that blank line I want that buyer no & its name...
So I can save this file naming with that cell value
Which contain buyer number & name ...which is now in cell
"A1"....

Code for Vlookup from buyer master can work..for fetch buyer name but
There are many files will generated & save it with name on fixed path
But for each file saving process each time buyer master open & closed by code to just fetch name
Is seems not good practice...

If code continues open buyer master for vlookup/index match in background
Till end of each file saving process completed.& closed if there are nothing
To process..then there are no need to autohotkey .that just put name after
Event recognised as clicked somewhere ,cursor blinking & entered that buyer no
& also put "-" sign there. So its instantly recognised &put the name there
As covert that entered string in "11345-Senator,Ahmedabad"... In that cell.

You can understand the matter is only continues open buyer master in background till all files
Saved for just fetching name for celll " A1" &merged Buyer no "-" & Name in cell "A1"..

Regards,

Chirag Raval.
 
You must log in or register to reply here.
Back
Top