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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,144,312
Messages
5,723,651
Members
422,508
Latest member
Lordkit1

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
Top