VBA Internet Explorer - Select Button *** HELP ***

**vbafreddie** · 12-11-2014, 11:44 AM

Hi All,

I am trying to automate the upload of data within Excel into SalesForce.com.

I have managed to complete 90% of the macro but am stuck on clicking a button and radio button on a pop up window. I have managed to locate the window and make it the prime window, but cannot seem to click the button.

Here's the code of the internet page, the button is on the very last line:

HTML Code:

I have tried the following without luck:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If anyone knows how to solve this i would be extremely grateful - also, if i have done anything wrong within my post please accept my apologies - this is my first

Thanks in advance

Freddie

**Leith Ross** · 12-11-2014, 03:50 PM

Hello Freddie,

The "Go" button is on an HTML Form. This is a separate HTML document from the parent document. Once changes have been made to the Form, it must be "Sumbmitted" to the server before the actions will be carried out.

Using the attribute "getElementByName" is not supported by the Input Submit element. It supports only "getElementById". But, this Input element does not have an ID. Since there are only two Input elements, you can return it this way...

Please Login or Register  to view this content.

**vbafreddie** · 12-11-2014, 05:20 PM

Hi Leith,

Thanks so much for the reply.

Unfortunately, it didn't work - it kicks out a Run Time 424 Error (Object Required) on the line "Set oForm = w.document.getElementById("theForm")"

I have put the full code of where this takes place so you can see that i am naming the 2nd window w - i have adapted your code to call it via w instead of IE.

Please Login or Register  to view this content.

Thanks again for your help in advance.

BR.

Freddie

**Leith Ross** · 12-11-2014, 05:28 PM

Hello Freddie,

You should post the workbook, so I can review your code. I think the prtoblem is with "w". You are most likely returning a interface object and not an executable object.

How To Post Your Workbook

At the bottom right of the Reply window, Click the button Go Advanced
At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
Click the Select Files button at the bottom middle of the dialog.
In the new window Find the file you want to upload, select it, and Click Open.
You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
Wait until the file has completely uploaded before you exit the File Manager dialog.

**vbafreddie** · 12-11-2014, 05:37 PM

Hi Leith,

No worries, here we go.

Thanks again!

Freddie

**Leith Ross** · 12-11-2014, 05:48 PM

Hello Freddie,

I needs some background on what is happening. My assumption is you are logging into the site first and then retrieving data from one or more pages and after that I am not sure.

**vbafreddie** · 12-11-2014, 05:54 PM

Sorry Leith,

Yeah you're right - firstly it logs into the site.

Then navigates to a particular page, where the data entry starts (the code loops through deleting every line that it puts into the website). This finishes here " 'Opens Lookup Window - SFDC"

This is then where i am stuck. It opens the popup window which is being defined (or at least i think it is) as "w" which also uses some code inside the module "PopupWindow".

Inside this popup (theform) i need to select the radio button "all fields" and click "Go!".

Here's the code of the popup window

HTML Code:

Hope it helps?

Ta.

Freddie

**Leith Ross** · 12-11-2014, 06:06 PM

Hello Fediie,

Gu dé? Since I can test anything directly because it is a secure site, I made a change to the code below so we can see what "w" is. The added code is in blue. Run this a let me know what it says.

Please Login or Register  to view this content.

**vbafreddie** · 12-11-2014, 06:10 PM

Hi Leith,

Well, fingers crossed this is what was meant to happen! In the immediate window it prints the name of the window "Search ~ salesforce.com - Unlimited Edition" - and the code runs through to the Stop that you added.

Ta

Freddie

**Leith Ross** · 12-11-2014, 06:12 PM

Hello Freddie,

What was the value of "x"?

**vbafreddie** · 12-11-2014, 06:15 PM

Hi Leith,

Sorry - new to this

x = IWebBrowser2

Ta

Freddie

**Leith Ross** · 12-11-2014, 06:42 PM

Hello Freddie,

I have been answering phone calls. I will put some code together for you test.

**vbafreddie** · 12-11-2014, 06:43 PM

Hey Leith,

No worries - i just appreciate the help!!

Ta

Freddie

**Leith Ross** · 12-11-2014, 07:37 PM

Hello Freddie,

Give this a try. This will replace all the code in the "Main" module. The IWebBrower2 interface is used to create an interactive HTML document from the MSXML2 library.

Please Login or Register  to view this content.

**vbafreddie** · 12-11-2014, 07:44 PM

Hi Leith,

Just tried it, and it brings a run time 91 error (object variable not set) on "HTMLdoc = Nothing"

Also, when it runs through the code (after i comment the above line out) it shows the msgbox - however, i have a feeling that it's linked to the HTMLdoc code.

Please Login or Register  to view this content.

Thanks again!

Freddie

**Leith Ross** · 12-11-2014, 08:06 PM

Hello Freddie,

Dògan! My typing has been bad all day.

It should be...

Please Login or Register  to view this content.

**vbafreddie** · 12-11-2014, 08:13 PM

Ah, no worries...

That got it past that, but instead now it makes the msgbox appear:

Please Login or Register  to view this content.

**Leith Ross** · 12-11-2014, 08:19 PM

Hello Freddie,

If the macro works properly up to the message box then you can delete that part of the code.

**vbafreddie** · 12-11-2014, 08:22 PM

Done!

It now throws up an error on this line .Open "GET", HTMLdoc.LocationURL, True

Same error 91, Object variable or With block variable not set.

Please Login or Register  to view this content.

Ta

Freddie

**Leith Ross** · 12-11-2014, 08:27 PM

Hello Freddie,

In that case, Internet Explorer is not running. You will need to restart it and rerun the macro.

**vbafreddie** · 12-11-2014, 08:29 PM

Hi Leith,

I closed IE down completely and restarted the macro. It pulled up the same error

Sorry!

Freddie

**Leith Ross** · 12-11-2014, 08:33 PM

Hello Freddie,

What URL is currently in you navigation bar?

**vbafreddie** · 12-11-2014, 08:36 PM

Hi Leith,

In the popup window it's - https://na6.salesforce.com/_ui/commo...lksrch=2315623

**Leith Ross** · 12-11-2014, 08:38 PM

Hello Freddie,

Okay, you get a popup window before or after the macro runs?

**vbafreddie** · 12-11-2014, 08:42 PM

Hi Leith,

It's during the macro, which is why i was trying to define it as "w".

In the code it starts:

Please Login or Register  to view this content.

It click a button on the main page where the data entry starts, then opens a popup window.

Then it waits to load the page and assigns the window to "w"

Please Login or Register  to view this content.

Thanks

Freddie

**Leith Ross** · 12-11-2014, 08:49 PM

Hello Freddie,

Then the macro is working fine up to this point and then you need to click a button on this pop up window?

**vbafreddie** · 12-11-2014, 08:50 PM

Hi Leith,

Exactly. It seems to define absolutely fine and prints the window name in the Immediate window.

I just then need to click on the radio button and go! button on the popup window.

Ta

Freddie

**vbafreddie** · 12-12-2014, 06:20 AM

Hi Leith,

Would it be better if i did a screen share with you so you can see the whole process working?

Thanks for everything so far!

Freddie

**vbafreddie** · 12-12-2014, 11:11 AM

Hi Leith,

I have managed to get it working using the following:

Please Login or Register  to view this content.

I am not sure it's the proper way of working through a sheet, but it certainly works - if you know of a neater or more methodical way then please feel free to let me know.

Thanks again for all your help!
Freddie

VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Re: VBA Internet Explorer - Select Button *** HELP ***

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to toggle focus between INTERNET explorer window and WINDOWS explorer window using VBA

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *

Re: VBA Internet Explorer - Select Button * HELP *