Procomm

[texaminn]

Ok, here's my scenario. I need to run the following script:

waitfor "OPTION - ^[[K"
transmit "1^M"
waitfor "<order#>-<ref#> - ^[[J"
transmit "5643-1^M"
waitfor "^[[7;40H"
transmit "nc^M"
waitfor "^[[7;50H"
transmit "nc^M"
waitfor "<order#>-<ref#> - ^[[J"
transmit "5674-35^M"
waitfor "^[[7;40H"
transmit "nc^M"
waitfor "^[[7;50H"
transmit "nc^M"


The transmit line after the "order #" and "ref #" line is the ACTUAL order # and ref #. In the above script it is "5643-1" and "5674-35".

Everyday I have to input those order #'s and reference #'s (hundreds of them) and then type the "nc" that's in the script as well. And everyday the order #'s and reference #'s change. I want to develop a way to change the order #'s and ref #'s (macro in word or excel?) in the script so I can just run the script and not to have to manually type them. Is this possible?

 

[knob]

You can use DDE to read the data from rows in Excel or line by line from a text file. I have samples for both on my site, link below.

http://www.aspectscripting.com

 

[kodr]

The right approach for you would depend on your source data.

 

[texaminn]

My source data is actually data that I retrieved via another script. I can pretty much make the source data anything, that's why I didn't know if I should make it a text file in word, or in columns in excel.

Knob...thanks for your answer on using DDE. I'll have to research that. Never done it before.

 

[knob]

If you can splat the data into a text file, I think that is easier to code and conceptualize rather than adding DDE to the mix. As kodr said, half the battle is what format your data is in.

http://www.aspectscripting.com