What do I tell a code to click a button?

[Nilannawen]

Hi,

I'm testing an upload in our current payroll system (Chris21) and am trying to import a file that will upload a batch of salary changes.
We have the original excel file converted to a text file using macros, but in the payroll system itself I need to tell the file to click 2 buttons (to recalculate the new figures) and to tick 2 check boxes (to apply the changes).

What do I need to tell the macros or the text file to click 2 buttons in a certain order, and tick 2 check boxes at the end?

Regards,
Nil.

[Dormilich]

a text file can't click anything. it's just text, nothing more, nothing less.

btw. what kind of check boxes are you talking about? This doesn't seem to be XML related either ...

[quocbinh77]

NUT XOA CO THONG BAO YES/NO:
Private Sub Command5_Click()
If MsgBox("BAN CO XOA KHONG.?", vbQuestion + vbYesNo, "THONG BAO") = vbYes Then
On Error GoTo errmsg
Adodc1.Recordset.Delete
MsgBox " DA XOA", vbOKOnly, "THONG BAO"
Exit Sub
Else
errmsg:
MsgBox "KHONG XOA..!", vbOKOnly, "THONG BAO"
End If
End Sub

[Nilannawen]

Hi,
Thanks for your response.
I understand the text itself is just text, but it prompts certain actions when we upload it to the payroll system.
We already have the command to create a new form for a certain employee, and apply an effective date (e.g. cbr=spmadd, detnumber="100001", spmeffdate="2017-07-01") but the next step we need is to click a button in the payroll system that will perform a preliminary auto-calculation so we have figures to adjust.
Does this help?

[Dormilich]

what is the program/language you use for that all?

[Nilannawen]

No idea to be honest. I know that's no help, it is straight into the payroll system. We've got a guy coming out in a week or so who might be able to show us, but we've been given the run around before. Thanks for helping though!