Hello all!
Here is the Scenario:
I have a spreadsheet that has all of the employee's names in the first coumn, and then thier In/Out status in the second, thier clock out time in the third, and thier time-to-be-gone in the fourth. The fifth column calculates the time of return.
I have an HTA that uses the NetSend command to broad cast the employee's name and how long they will be gone to all of the machines in the domain. I would really like for the HTA to populate certain cells in the spreadsheet, but have no idea how to go about this. The spreadsheet is layed out like this:
Employee Name Status Out Time Return
Employee 1 IN
Employee 2 OUT 9:30AM 0:30 10:00AM
Employee 3 IN
Employee 4... etc
The HTA has a dropdown that includes the employee's names, and a second drop down that has time intervals. (30min, 60min, etc,...)
The logic I have is that when the user presses the submit button, I would like the HTA to find the correct row (matching the user's selection of name), and enter the time submitted, and the time they selected as time-to-be-gone in the correct row. I will be happy to provide source code for my HTA. PLEASE HELP! It's driving me absoultely mad!
[∞]MP
Here is the Scenario:
I have a spreadsheet that has all of the employee's names in the first coumn, and then thier In/Out status in the second, thier clock out time in the third, and thier time-to-be-gone in the fourth. The fifth column calculates the time of return.
I have an HTA that uses the NetSend command to broad cast the employee's name and how long they will be gone to all of the machines in the domain. I would really like for the HTA to populate certain cells in the spreadsheet, but have no idea how to go about this. The spreadsheet is layed out like this:
Employee Name Status Out Time Return
Employee 1 IN
Employee 2 OUT 9:30AM 0:30 10:00AM
Employee 3 IN
Employee 4... etc
The HTA has a dropdown that includes the employee's names, and a second drop down that has time intervals. (30min, 60min, etc,...)
The logic I have is that when the user presses the submit button, I would like the HTA to find the correct row (matching the user's selection of name), and enter the time submitted, and the time they selected as time-to-be-gone in the correct row. I will be happy to provide source code for my HTA. PLEASE HELP! It's driving me absoultely mad!
[∞]MP
