Hi,

I wanted to find out if there was a way to design a macro that takes information from a column in Excel to a text box on a webpage. I have over 600 records that I can input 15 at a time. I would like to run a macro so that I don't have to manually copy and paste these items. Is this possible? I am fairly new to VBA programming. Any help will be greatly appreciated. Thanks.

Also, it is a site that my co-worker logs me into so I cannot instantiate it as a new instance of Internet Explorer. I need a way to establish a connection with the existing page already opened up in Internet Explorer.

Use the browser object, open it and then add text to the specific boxes you want to. have a look at THIS link, it will show you how to add the browser.

Once that is done, you will use code similar to this to interact with the browser -

Dim HTMLDOC As HTMLDocument
Dim HTMLI As HTMLInputElement

Set HTMLDOC = myBrowserName.Document

    For Each HTMLI In HTMLDOC.getElementsByTagName("input")
        If InStr(HTMLI.Name, "GreetingName") Then
            HTMLI.Value = myValueIwanttoadd
        End If
    Next

    For Each HTMLI In HTMLDOC.getElementsByTagName("input")
        If InStr(HTMLI.Name, "Password") Then
            HTMLI.Value = the passvalue
        End If
    Next

    For Each HTMLI In HTMLDOC.getElementsByTagName("input")
        If InStr(HTMLI.Name, "Submit") Then
            HTMLI.Click
        End If
    Next
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.