I have to import text files in ms excel too much and for that I have to first click on Data tab and then From Text button. As you can see in this screen shot-
In the above screen shot, you can see there is a button named- From Text in the red box, I want that whenever I press f1 hotkey then it should show Import Text File dialogue box as shown in the below screen shot-
In the above image, you can see a dialogue box which appears when we press From Text button, but I want to appear it when I press f1 hotkey. I know there are several other ways to show this dialogue box, like we can press shortcut key- ALT then A then FT. I know we can use controlclick or mouseclick command also for this purpose, but I want some static codes to do this task.
First I tried to use PostMessage command like this-
Code: Select all
f1:: PostMessage, 0x111, ????,,, Microsoft Excel - Book1 Return
Please help me..
Thanks a lot..