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.
Bookmarks