Sorry but the help is OK. I repeat the help file is OK.
My mistake. I was not using the proper handle. By using it:
Everything worked as the helpfile says it.

There is always something to learn.

DingDong

Hello, I finally manage it. The help file says: If WIN_USEHANDLE is set to 1 WindowTitle must be a window handle. I followed it and it did not worked. I edit the script with the following: Let>WIN_USEHANDLE=0 SetControlText>Tradition*,ThunderRT6TextBox,15,%Nom_Client% and the SetControlText worked. ...

Hello, I edit the script with the following: ////Démarrer Trad T-20//// Let>RP_WAIT=2 Run Program>C:\Desjardins\Suvriq\Suvriq.exe /SUVRIQ /REP:100 /PROD:T20HARMTRAD WaitReady>1 Wait>5 ////////////Attendre l'ouverture de Traditionnel en Fr ou An Let>WIN_USEHANDLE=0 WaitWindowOpen>Tradition* SetFocus...

Thank you mtettmar for your reply.

The Excel version is 2003.

Here's a view of the textbox control (wich is ThunderRT6TextBox in the Viiew System Windows tool utility) where we see the label Nom.



thank you!

Thank you mtettmar for your quick reply. What I want is to set set a value in the window control not to set a value in a spreadsheet cell. By reading a thread on this forum about the SetControlText command to accelerate the automation of a gui instead of of sending keypress it gave me the idea to us...

Hello, With the following code I am able to identify a and move to a ThunderRT6TextBox. But when I use the SetControlText with a value from an Excel spreadsheet, that command does not work. I have tried with a simple string an that does'nt work. I have use the the View System Windows to confirm the ...

Thank you JRL, the last parameter was the problem.

You just made my day, still in the am in Canada.

DingDing

Hello, Could someone help me to correct this piece of scripting. The following won't work: RunProgram>C:\Desjardins\Suvriq\Suvriq.exe /SUVRIQ/REP:100/PROD:UL,1 But will work in Excel VBA, so I know the command line is OK: Sub ActivateMyLine() Dim A A = Shell("C:\Desjardins\Suvriq\Suvriq.exe /SUVRIQ ...

mtettmar,

I understand now, thank you for your patience and your eplanations.

DingDong

Thank you mtettmar,

Could you tell me how will I retreive the data inside the row bring by the first statement and show it in a message.

Thank you mtettmar and adroege for your reply. By changing the statement to: With the following Let>SQL=SELECT ClientID FROM Clients The result show in the message is 4. With the COUNT(*) function the result is still 1. The ClientID field is an indexed field and null value is not permitted.

Hello, Database Table Clients has 4 records. I run the following script and the return result is 1. I would expect 4. Is there a problem with the DBQuery function or the script? Thankyou! //Connect to Datasource // Let>str=Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\sample.mdb;Uid=Admin;Pwd=toto...

Thank you JRL for your answer.

I have edit the script with another DB and the script worked.

This post should be edit as solved.

Again, thank you all.

Thank you adroege for your answer. I have adjust the code. //Connect to Datasource // Let>str=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Desjardins\Suvriq\Repres.mdb;User Id=admin;Password=XGVDLX; DBConnect>str,dbRep // //Perform SELECT query // Let>SQL=select * from CLIENTS DBQuery>dbRep,SQL,C...

Hello, Register to MS 11. Running it from XP SP2. I want to connect with ADO to a pw protected MSAccess DB located on the C:\ drive. I run the following script without success. //Connect to Datasource // Let>str=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Desjardins\Suvriq\Repres.mdb;User Id=adm...