Key Strokes

[ermccarthy]

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!!

 

[Damon Ostrander]

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.

 

[Bruno_x]

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>

 

[Marc]

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/

 

[Bruno_x]

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...