Setting Variables Syntax Problem - What am I doing wrong?

Hello,

The VBA script I wrote in the attached workbook, works like this > when executed it goes to a URL, selects a radio button, then a submit button, the the webpage changes. That works perfectly. Also there is additional code that inserts information from the Workbook into the webpage. Thats where my problem is.....

After the the Macro selects the radio button and submit button, the script stops passing information to the webpage for some reason...Does anyone know why that might be? After the radio button is selected my Macro is supposed to pass information to the rest of the form. Any ideas what my issue could be? I think it has something to do with this statement, but Im unsure

Please Login or Register  to view this content.

But Im unsure, so any help is greatly appreciated!
SEDI Macro.xlsm

Hey Norie,

Thanks for the response. The code executes and works to change the webpage...However VBE is giving me an error at this line:

Please Login or Register  to view this content.

I used getElementsByName instead of by ID, because I couldn't find any element ID's in the HTML code, but maybe I just didnt look hard enough. I only skimmed it quick and jotted down the element names instead of ID's.

Do I need to change getelementsby name to elements by ID?

Originally Posted by Norie

Where exactly does the code stop?

Are there any error messages?

I see what your saying. What I was trying to do with those drop downs, is have the user select what option they want on the workbook, then have the workbook pass it to the webpage (for example: month/day).. So I guess I should use different indexes then huh. What should I use if there are no ID's for each element on the form? For example, the drop down for picking the month doesn't have an ID in the HTML code that I can see.

Originally Posted by Norie

The only part of the code that will work is the part that selects the tpe of report.

The 2nd part, even if it could access the form, will not pick the correct type, search type, days/months/years etc for the search.

One reason for that is you are using incorrect indexes for some of the dropdowns.

Another reason is that you are treating certain dropdowns as text input fields.

Hey Norie,


So for instance, for the drop down that says, "Insider Company Name" - in the HTML code I see, name="SELECT_TYPE"> wouldn't "SELECT_TYPE" be the name I use in GetElementsbyName(), then set it to value = 4, since the option "insider company name" is value 4?

Thanks again for the help.

Originally Posted by Norie

I was able to access all the controls by name.

Oh I see, so instead of

Please Login or Register  to view this content.

I should make it

Please Login or Register  to view this content.

Ill try that out in a few minutes here.

Originally Posted by Norie

No, it's the index of the item you want to select, not it's value, that you need to use.

Hey Norie,

Thanks for the help today with this issue. I came up with another way of doing it, but haven't perfected it yet. I did some more reading and read that when Im changing a drop down, I use to have something called on change....So is this little closer to what I need to be doing? Hard to find information on this topic online.

Please Login or Register  to view this content.

Originally Posted by Norie

No, it's the index of the item you want to select, not it's value, that you need to use.

Hey Norie my bad. My VBA skills are bad haha. Im kind of confused because I thought if I wanted a specific selection picked from the drop down I would have to tell the form exactly what to select?

Basically in the worksheet, if a user selects the option "Insider company name" from the drop down I made....When the macro runs it should select "insider company name" from the drop box on the webpage. Basically what Im doing is similar for all the fields on this webpage.

There is a section in the worksheet where the user can select from drop downs, and enter text when necessary and when the Macro runs Im trying to get it so it takes the information from Excel and fills out this webpage....So that being said is it still necessary to scrap that code? If so I can and try and approach this a different way.

Thanks man! for responding and helping so much.

Originally Posted by Norie

You don't need that code.

If you select the correct items from the various dropdowns and then click search everything works.

Well I assume it works as it returns something.

Hey Norie

Thanks pal!

Alright, Im going to alter it, see if I can make it work. What you said totally makes sense. I remember reading about 0,1,2, etc...I just totally forgot!

Ill keep ya posted on how it goes.

Thanks Norie!

Originally Posted by Norie

You don't really need to totally scrap the code, you just need to tweak it differently.

On a webpage to select a particular option in a dropdown you normally set the selectedIndex.

The selectedIndex is not the value you want, it's the index, or position, of that value in the list of items the dropdown displays.

Also, and this is quite important, the index of a dropdown is 0-based which means the 1st item has index 0, the s2nd index 1, the 3rd index 2 and so on.

As for FireEvent, that would be used when there was code for the dropdown that you needed to execute.

For example, if you had dependent dropdowns there might be code in one dropdown that updates what's listed in another dropdown list based on what was selected in the first.

Oh, just remembered something else - there is no getElementByName.

Sorry, should have mentioned that right away.