Copy from excel into form.

abjac

Board Regular
Joined
Feb 18, 2013
Messages
74
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.
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
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Just to inform so nobody would work double.Some in Ozgrid forum have now been so nice to try solve this thread for me. So i cross fingers. Can be found in upper link. Thanks Abjac
 
Upvote 0
This thread is now solved thanks to a fantastic work from Cytop. See upper link. thanks
 
Upvote 0

Forum statistics

Threads
1,215,385
Messages
6,124,626
Members
449,174
Latest member
Anniewonder

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top