Fill .pl web form from Excel

**magicalball** · 01-26-2013, 10:31 PM

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:

Please Login or Register  to view this content.

I gotta believe I just need to use another application for CreateObject, but I don't know what it is.

**Norie** · 01-26-2013, 11:07 PM

Is ghastly the actual URL in the code?

**magicalball** · 01-27-2013, 06:23 PM

Not sure if I understand what you're asking, but the URL in the sample code is just a sample. The actual website is on an intranet.

When the line

Please Login or Register  to view this content.

executes (using the actual URL) it does take me to the correct website, but the IE Object then becomes Nothing in VBA.

Fill .pl web form from Excel

LinkBack

Thread Tools

Rate This Thread

Display

Fill .pl web form from Excel

Re: Fill .pl web form from Excel

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions