Key Strokes

ermccarthy

Board Regular
Joined
Feb 15, 2002
Messages
224
I use a company specfic program at work. I always open my Excel workbook that has the figures located in it, and I copy it (ctrl-C) toggle to that window (Alt-Tab) paste it in the system (Ctrl-V) and then Page Down (with the keyboard button) and toggle back to Excel to get the next set of data for pasting. Can I record a macro that will record and preform my actions to run in the other window based system, even if it not excel?

I have asked & tried, I can not just export the data to the program.

Please help!!
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Hi Russell,

No, Excel will not record keystrokes that occur outside of the Excel application process (window). In fact, Excel does not really record keystrokes at all, not even inside Excel. Rather, it records Excel object model operations. And since some Excel operations are not defined in the object model, these operations are not recorded--so you can't necessarily to anything in a macro that you can do manually--at least not the same way.

In your case, you can probably get an Excel macro to do the appropriate keystrokes for you (using the SendKeys method), but you will have to write the macro yourself. This will only work if you can do everything that needs to be done in your other application via keystrokes. That means that you would have to identify the area that you want to select for cut or copy via keystrokes alone. Most applications are written so that they can be operated from a keyboard only, and if this is the case you are in. But even so, it is sometimes the case that an operation that is trivial to do manually (for example, identifying a certain sentence in a body of text) is daunting to do programmatically.
 
Upvote 0
You could use some vbs code like this :

Adjust the 'SENDKEYS' strings to your needs...

<pre>
set objShell = WScript.CreateObject("WScript.Shell")

' simulate the keys
objShell.sendkeys "{Enter}{Enter}"

' to start another program
objShell.run "C:MyProgram.exe"

' if you have to wait...(time in millisec.)
WScript.Sleep 3000

' other examples
objShell.sendkeys "%c"
objShell.sendkeys "Z"

</pre>
 
Upvote 0
I have to do a similar task and I found a great program on the net called Macro Express 3. It will allow you to take data from excel, process it in your company app and do whatever you want to it. It's free for 30 days and then costs around thirty bucks. Here's where they're at.

http://www.macros.com/
 
Upvote 0
Another easy solution :
use the macro recorder of Windows 3.1x

This little program records keystrokes and mouse movements. I've used every day until I'v learned some vbs code...
 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,342
Members
448,570
Latest member
rik81h

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