Dear Friends
Please excuse me if this is not the correct section for this thread.
I'm trying to import html based table in excel using web query. data gets fetched for the default selected items in the dropdown box but not for rest of the items in the dropdown list. I guess, a javascript seems to be the catch.
I've to select other items form the dropdown box and click on 'Go' to get the table in web browser but have no clue how to get it done automated for excel web query.
here is the link to the page.
on googling I figured out that there could be a way if one can code a macro to submit the javascript form but I didn't understand how to do it.
I'm not so familiar with html and javascript, please help me out.
Thanks