IE.Document.getelementbyid("departmentId").Value = Cells(y, 1).Value ' Enter Department from Excel
IE.Document.getelementbyid("classId").Value = Cells(y, 2).Value ' Enter Class from Excel
the page looks like this with a lookup box besides for both department and class.
lookup box when clicked shows all departments and one of it can be selected by clicking or entering the number also works..
same with the class field
Dept059 [](there is a box where i can click , all the departments are housed which i can select.this is not necessary if i enter the number)
Class
13 []
while typing manually into IE when i enter 3 digits in the dept field the cursor automatically moves to the class field..however while using the code to make the entry the department is being entered while class is not being entered (it is greyed out i.e. not selected)..is it because of the lookup or should the code be altered.
Thanks in advance
IE.Document.getelementbyid("classId").Value = Cells(y, 2).Value ' Enter Class from Excel
the page looks like this with a lookup box besides for both department and class.
lookup box when clicked shows all departments and one of it can be selected by clicking or entering the number also works..
same with the class field
Dept059 [](there is a box where i can click , all the departments are housed which i can select.this is not necessary if i enter the number)
Class
13 []
while typing manually into IE when i enter 3 digits in the dept field the cursor automatically moves to the class field..however while using the code to make the entry the department is being entered while class is not being entered (it is greyed out i.e. not selected)..is it because of the lookup or should the code be altered.
Thanks in advance
