In a Aspect Script, can you "Find" in Excel and then use the info from that Row?

[esoare]

In a Aspect Script, can you "Find" in Excel and then use the info from that Row?

The benefit is, that inside a dialog box, I would get asked for the "DN" and then a search would be done (Maybe only search the "DN" column?) after the "DN" is found, the data would be "gotten" through the normal way with the Dll stuff.

Is this possible? Is this a dream?

Thanks,
Esoare

 

[knob]

I'm not sure there's a direct way to do a search via DDE, but you could write a script that can use the sendkey/sendkeystr/sendvkey commands to manually drive Excel to bring up the Find dialog, search for the string, and close it, leaving you on the necessary row. That would be the brute force way to do it, at least.

http://www.aspectscripting.com

 

[Firebird Scrambler]

Some of my scripts use a *.csv as a source file. One example is located here at..

http://www.tek-tips.com/faqs.cfm?fid=7284

All the best

Firebird Scrambler
Meridian 1 / Succession and BCM / Norstar Programmer in the UK

http://www.linkedin.com/in/davidbromley

If it's working, then leave it alone!.