quick little data entry helper

[sassyt]

Can this be done?
I have to type in 040102, 041502, 041602 and 043002 about 70 times in a peoplesoft program.
Is it possible that create a small program that will allow me to click on a button which will auto-fill an active field with one of these numbers. Maybe a form with 4 different controls that write to the field that my cursur is currently in. I am running Windows NT and I often need this technique in several programs that are not MSOffice programs.
Any Suggestions?

[MySt]

well a macro should do that ,i'm have never made one though :) .

but i am sure that sumone will have ,and will give detialed info on it :) .

[Tonker]

Hi Sassyt,

It's probably possible to do what you're proposing. Visual Basic might be one possible route for you. I'm not too sure what other scripting languages might be applicable here.

Unless you're going have to do this a lot, for example entering those numbers 70 times everyday, it's probably not worth investing the time in developing an automated solution. It might make a fun activity if you're bored, though. :)

I've run into a similar situation before and have found that you don't always save yourself time if you have to develop an automated solution.

An easier solution might be to copy and paste. Copy the value '040102' to the clipboard and paste it into every field that you need to put it in (using ctrl + V), then repeat for the other values you need.

Good luck!

BTW Welcome to HFT! :D

[sassyt]

I wish it were as easy as a cut and paste, but there are 3 cells that have to be tabed to on each panel that I am working on. This stuff should be programatically entered into the table but the programmers here can't figure it out so I have to key them. What it boils down to is about 550 keyed cells. And this type of thing happens often. I want to create something that I can plug in a few values for any project that I am working on and the click the right button to load the info. Ok if I go the vb route...in which I am a novice what am I looking to do. I know how to put controls on a form and put simple code behind it, but I want a couple of input boxes that I can put data in and then the box beside it can copy what is in that box and paste it into an active cell.

:rolleyes:
hmmmmm
Tami
Thank for the welcome!!!

[Tonker]

I'm not that experienced with VB either. It would probably involve getting the window handle of the Application you're trying to copy the data into. You'd have to decide how you want to enter the data, i.e selecting the value from a menu or something, then decide how you want to input it into the application.

What OS are you using? I think the new (98 and up) systems have a basic scripting ability that might be easier, although I've never tried them. I also remember my OS teacher in college mentioning that you can get the macro generating application from windows 3.1 to work under 95. It captures keystrokes and mouse clicks. that might help you.

Another (perhaps easier) approach, assuming that the data you are entering gets stored in a file, would be to create an application that would access the peoplesoft file you are using (if you know the data format) and add the values you want to enter right into this file.

Hopefully we have a VB guru on the board who can discuss the options for using VB more fully - Don't be shy!! :D Unfortunately I only played with it a bit in college, and never got into manipulation other applications with it.