Using Excel (VBA) to populate other programs

[Tim in Toronto]

Hi All,

Does anyone know if there is an Add-In that will allow me to take info within an Excel sheet, and populate that info into a non-Microsoft program?

I'm trying to find a way to automate uploading data into our mainframe terminal window. Nobody in my company seems to know how to do this, so I'm kind of on my own.

Let's say my sheet contains product numbers, prices, Units of measure etc. I want pick up each of those values and paste them into each field in this terminal window so that I can update our mainframe. It's a really, REALLY old archaic system. But hey, it works )

If there is any Add-In, or script ideas out there, I'm all ears.

Cheer!

 

[hiker95]

Tim in Toronto,

See if this will help you:

Automation of an system issue.
check out autoit
http://autoitscript.com/autoit3
it's a free, high level basic based programming language that makes working with all areas of the windows API pretty simple.
including sending directly to any standard control.
Easy to learn BASIC-like syntax
Simulate keystrokes and mouse movements
Manipulate windows and processes
Interact with all standard windows controls
Scripts can be compiled into standalone executables

 

[shg]

Interesting link, hiker. Got an example of how you've used it?

 

[hiker95]

shg,

I have not had an opportunity to use it.

I found it here:
Automation of an system issue.
http://www.vbaexpress.com/forum/showthread.php?t=35623

 

[shg]

Thanks, h.

 

[jimrward]

what mainframe terminal emulation program are you using ??

does the data need to go into one field or multiple fields on the mainframe ??