Hello everyone.
I have sort of an odd question.
I would like to know if i can use VBA to perform a task in another program.
I would like to accomplish this by using the shortcut keys that this other program uses.
For Instance, In this program I have to hit Alt+S and then Enter about 500 times and i would like to create a macro or program that does this automatically.
Now Keep in mind that I need a macro that basically is a virtual representation of me hitting these keys repetitively.
I have read up on the Windows API and using the User32.exe file, but I do not understand exactly how this works or even if what I need is possible.
If anyone has experience with the User32.exe and Windows API programming. I would love to know if you think this is possible. Or if you know another way to accomplish this task.
I would love to hear any input that you might have.
Thanks
Wren
I have sort of an odd question.
I would like to know if i can use VBA to perform a task in another program.
I would like to accomplish this by using the shortcut keys that this other program uses.
For Instance, In this program I have to hit Alt+S and then Enter about 500 times and i would like to create a macro or program that does this automatically.
Now Keep in mind that I need a macro that basically is a virtual representation of me hitting these keys repetitively.
I have read up on the Windows API and using the User32.exe file, but I do not understand exactly how this works or even if what I need is possible.
If anyone has experience with the User32.exe and Windows API programming. I would love to know if you think this is possible. Or if you know another way to accomplish this task.
I would love to hear any input that you might have.
Thanks
Wren