Results 1 to 3 of 3

Fill .pl web form from Excel

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2013
    Location
    Kentucky
    MS-Off Ver
    2010
    Posts
    2

    Fill .pl web form from Excel

    I need to populate a form on a website with a .pl extension (Pearl?) with data I have in an Excel file. I hunted the web and found methods for populating .html websites but they don't work on .pl. As soon as I have it navigate to the website it no longer is an Internet Explorer Object, but I don't know what kind of object it becomes. Here's some code to help clarify:
    Sub FillWebForm()
    
    Dim MySheet As Worksheet
    Dim IE As Object
    
    URL = "http://webaddress.pl"
    Set MySheet = ThisWorkbook.Worksheets("Data")
    Set IE = CreateObject("InternetExplorer.Application")
    
    IE.navigate URL
    
    ...more code that doesn't matter because IE becomes Nothing when the last line executes.
    End Sub
    I gotta believe I just need to use another application for CreateObject, but I don't know what it is.
    Last edited by Leith Ross; 01-27-2013 at 12:48 AM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1