Possible to open Mozilla Firefox with VBA script?

[brooksc29]

I have a VBA code that will open an instance of Internet Explorer:

Dim ie as object

Set ie = CreateObject("InternetExplorer.Application")

what I'm wondering is, does anyone know if I can use Mozilla Firefox instead of Internet Explorer? IE is giving me all sorts of issues when opening.

 

[jc.021286]

As far as I know, no, I've had tons of problems with web queries in the past.

Just remember, MICROSOFT Excel, MICROSOFT Internet explorer.

http://www.mrexcel.com/forum/showthread.php?t=236618

They have a preference to linking through their own software.
jc

 

[brooksc29]

is there a good way to show you my VBA and see if there's something wrong with it?

Basically what I am trying to do is open IE, sign into a password protected site, and copy/paste tables of data onto a worksheet.

The problem runs into IE entering the username and password and signing in. The code stops at that point and does nothing, even though I have both the u/p in the VBA.

 

[jc.021286]

for the actual tables, that is a web query.

If I recall correctly, if you sign in prior to running the query, you should be good. Or you need to have the query wait 5-10 seconds for your U/P to be authenticated first.

Thus, split the macro into 2, log in with the username and password and then use the onTime function to call the next one in a few seconds to attempt to do the web query.

Also, if you are already signed in, does that cause an issue? Thus, perhaps having your 2nd macro actually sign you out afterward would be prudent, to ensure that if you ran the macro again, it would not cause an issue with already being logged in.

Jc

 

[JP2112]

You can run any program using the Shell function, i.e.

Shell "C:\Program Files\Firefox\firefox.exe"

If you need help debugging your code, post it using code tags like this:

[CODE]your code here[/CODE]

You might also visit http://www.dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/ and check out a method for doing exactly what you described.

 

[obeidat]

hello,
can you please tell on how can we get data from firefox using vba, step by step?