Hey :) I have a problem with the macro, I learn only and do not know how I got this same bite: ( Macro has come to the site to enter something in the field from an Excel spreadsheet "A1" and enter, then has to check whether you have previously entered "field" occurs on the page, if it goes further writes the value of the Excel sheet "B1" if it does not have to go back and start from scratch or from entering into the field of cell "A2" enter - checks etc :) I would be grateful for your help :)))) For the test I gave Google page If a bad place where I entered this topic please move it :) Thanks
Sub test() Dim IE As Object intRowPosition = 1 Set IE = CreateObject("InternetExplorer.Application") IE.Navigate "https://www.google.pl/" IE.Visible = True While IE.Busy DoEvents Wend While Arkusz1.Range("A" & intRowPosition) <> vbNullString IE.document.Forms(0).all("q").Value = Arkusz1.Range("A" & intRowPosition) While IE.Busy DoEvents Wend IE.document.Forms(0).submit While IE.Busy DoEvents Wend If IE.document.Forms(0).all = ("q") Then IE.document.Forms(0).all("q").Value = Arkusz1.Range("B" & intRowPosition) While IE.Busy DoEvents Wend Else Application.SendKeys ("{Backspace}"), True intRowPosition = intRowPosition + 1 End If Wend Set IE = Nothing End Sub -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.