VBA to access Windows

wren17

Board Regular
Joined
May 25, 2002
Messages
52
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
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,215,054
Messages
6,122,897
Members
449,097
Latest member
dbomb1414

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top