Call Javascript in VBA using IE object / update DateDropBox

**shahzeb** · 03-04-2014, 07:59 PM

I am trying to change the value of the date dropbox on the following website. Whereas my code does change the value, when I click the Show Prices button, the date has not changed. It gets me prices for the dates I chose when I clicked the webpage with the mouse. Could someone please tell me what I am missing?
Thanks for your help!!

Webpage
http://www.tripadvisor.com/Hotel_Rev..._New_York.html

Html Code:

HTML Code:

My Code:

Please Login or Register  to view this content.

**berlan** · 03-05-2014, 04:38 PM

Hi shahzeb, try this as a start. I disabled the date dropdown, which I think is the most simple way to do it:

Please Login or Register  to view this content.

Cheers,
berlan

**shahzeb** · 03-07-2014, 02:36 PM

Thanks Berlan.
That did not do the trick but it did get me thinking along the correct direction.
Setting the text field to the desired date does not do that trick... i had to invoke the following procedures to store the dates

.Document.parentWindow.execScript "ta.store('multiDP.checkIn', "03/07/2014");"
.Document.parentWindow.execScript "ta.store('multiDP.checkOut', "03/08/2014");"

I guess there is some "lazy" code that loads forms after the whole document loads (depending on my actions on the page)... so I need to invoke other procedures to update the prices for newer dates? Am I thinking along the correct lines?

And again, thanks for your help. It is much appreciated!

SZ