HI I would like to know if there is any solution for copy to a form from excel, which is not in a webpage but and server logged in form.
I have this code which works perfect in internet explorer.. And i also have the finish program called roboform, which can do all in different webbrowsers. But none of these can copy into a server based formfield program, which is opened on a server and demand alot of fileld inputs.
I would be happy if som have a solution for this, from excel. So i can save this form field input. And when i open it, i can just past into the fields with excel.
Please havea a look
Sincerely
Abjac
This is my working form for internet explerer.
I have this code which works perfect in internet explorer.. And i also have the finish program called roboform, which can do all in different webbrowsers. But none of these can copy into a server based formfield program, which is opened on a server and demand alot of fileld inputs.
I would be happy if som have a solution for this, from excel. So i can save this form field input. And when i open it, i can just past into the fields with excel.
Please havea a look
Sincerely
Abjac
This is my working form for internet explerer.
Code:
Sub Fill_Form1()
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = True
.navigate [URL="http://www.mrexcel.com/forum/="https:whateverloginpage"]URL:="https:whateverloginpage[/URL] there is "
Do Until .readystate = 4
DoEvents
Loop
Set mytextfield2 = .document.all.Item("username")
mytextfield2.Value = Sheets(1).Range("A1").Value
Set mytextfield2 = .document.all.Item("password")
mytextfield2.Value = Sheets(1).Range("A2").Value
End With
End Sub