Send to a DOS

[Jos]

I'm with you - DOS accounting program???

Actually, I have one too which I still use... but hey, I am Dutch too.

[herewasplato]

@Zompy,

So - if I have summed up your request - please post the name of the DOS accounting program and maybe Jos (ad others) can get you started with your script.

If I got it wrong - please correct the order that you manually do things between the spreadsheet and the DOS app so that those helping can know the order that the script should be in.

[Yashied]

Maybe you were/are ready to creamate this youngster.

herewasplato, what do you meant by the word "youngster"? Small amount of posts? Edited March 26, 2009 by Yashied

[herewasplato]

herewasplato, what do you meant by the word "youngster"? Small amount of posts?

When the OP said:

Willk do, got kicked off my computer by my dad, lol =/

I gathered that the OP is in the younger stages of life (and uses the term lol). While there are a few scenarios that I can think of where one's father could kick a child off "his?" computer - the most likely scenario is that the OP is much younger than me.

Now - having rambled thru all of that - if you were just looking for a definition for the word - in context: it just means a young person - a child. It has little to do with actual age, because as I get older the age of youngsters goes up.

Youngsters can be old enough to have kids of their own. When you call a person that is that old a "youngster", you are making more of a statement about your own elderly age that the true youthfulness of the other person.

But I don't want to high jack this thread to much...

Edited March 26, 2009 by herewasplato

[Yashied]

When the OP said:

Willk do, got kicked off my computer by my dad, lol =/

I gathered that the OP is in the younger stages of life (and uses the term lol). While there are a few scenarios that I can think of where one's father could kick a child off "his?" computer - the most likely scenario is that the OP is much younger than me.

Now - having rambled thru all of that - if you were just looking for a definition for the word - in context: it just means a young person - a child. It has little to do with actual age, because as I get older the age of youngsters go up.

Youngsters can be old enough to have kids of their own. When you call a person that is that old a "youngster", you are making more of a statement about your own elderly age that the true youthfulness of the other person.

But I don't want to high jack this thread to much...

OK.

[lilx]

well, it seems that zompy has some trouble with his english (not that i am the best in it ), but because your question are so vaque try to type your qeustion in dutch and maybe i can help you or translate for you

[Yashied]

I think that is the problem here is not in the language. It depends on how much a person needs help which he requested. I recognise that I was too rough in my post. I am sorry, Zompy.

Zompy, write at least the name of the program.

[Zompy]

The program is called AR it's an old, and actually unique program...

Ill explain for i want for the last time.

I got an excel file,

i want the bot to read the excel info from A1, then type it into the program and send enter, then read A2 etc etc

till A5, then start with B1 till B5 etc

It depends each time how far the letter is going.

[lilx]

my advice would be try looking at the following link:

http://www.autoitscript.com/forum/index.ph...02&hl=excel

and try to look at the following topic in the help this may come in handy i think:

WinActivate

WinActive

WinExists

Send

Send Key list

[youknowwho4eva]

I worked with Zompy on the Excel part. That part should be down. The issue is Send not working for this AR program.

[Zompy]

Send doesn't even work when i set sleep 10 secondas, i type something (to etst if it works) and i remove it, then the send command gos active but doesnt do anything.

[youknowwho4eva]

What about using _ClipBoard_SetData

Seeing {enter} works

Perhaps send("^v") will work

[Zompy]

So what script i gotta enter?

[youknowwho4eva]

If you still have it the way we discussed

You have to have

#Include <Clipboard.au3> at the top

then have in your for loop after the excelreadcell

_ClipBoard_SetData($cell[$f][$i])

If I remember correctly.

[Yashied]

The program is called AR it's an old, and actually unique program...

Ill explain for i want for the last time.

I got an excel file,

i want the bot to read the excel info from A1, then type it into the program and send enter, then read A2 etc etc

till A5, then start with B1 till B5 etc

It depends each time how far the letter is going.

Zompy, I really want to help you, but (without resentment) your answers give rise to further questions. Indeed, what is "AR"? "AR" is not the name of the program, this is abbreviation. If I tell you that I'm using a program of "AB" or "WR", then you will understand what programs are we talking about? Here, even Google will not help. Maybe this is not the name of the program, it can be a file name - "AR.EXE"? If you can, give a screenshot of its program ("AR").

Let us now to your topic. I understand from your answer following. You want to get data from Microsoft Excel and then paste them into some input field in the DOS-program ("AR"). So? Then you will actually use the Send(). But the fact that Send("Hello") does not send a word "Hello", it "emulates" consecutive pressing of keys - "H", "e", "l", "l", and "o". In any case, you first need to set the focus (cursor) to the input field (within the program "AR") in which you want to insert the data. Guess as it to make. Using the same Send () function. Most DOS-programs can be used for switch cursor the following keys "Tab" and "Up", "Down", "Left", and "Right" arrows. It is not difficult to understand the need by using the Send() function send the right amount of pressing, such as "Tab". It will look like as Send({TAB n}). Here "n" - quantity of pressing. Once the cursor is in the appropriate input field you can send the data, Send("Hello"). Etc.

local $Data
...
WinActivate("C:\WINDOWS\system32\cmd.exe")
Send("{TAB n}")
Send($Data)
...

If I did not understand you correctly, there is no need a peeve. Just explain in more detail about what you ask, those who want to help you. Indeed, in this case you need help, not me. And more. I understand for many in this forum English is not their native language (for me too), therefore, Zompy, please carefully at the phrases, so that later there was no puns as in this topic. If you are using Google Translate, I recommend that you check the result (sometimes get the translation with the opposite meaning).

Good luck.

P.S.

I would like to ask that so special about this program ("AR"), that you can not refuse it, or find a worthy replacement? Say?

[E1M1]

You must wait until window is active and then send keys

local $Data
...
WinActivate("C:\WINDOWS\system32\cmd.exe")
WinWaitActive ( "C:\WINDOWS\system32\cmd.exe" )
Send("{TAB n}")
Send($Data)
...

[Zompy]

The send doesn't work! is aid that ebfore.

And the name is A&R but as i said it's very unkown.

[Yashied]

The send doesn't work! is aid that ebfore.

And the name is A&R but as i said it's very unkown.

Screenshort!?

And let decoding of "A&R".

Edited March 27, 2009 by Yashied