Help with VBA loading javascript page

AppleZapple

New Member
Joined
Feb 29, 2016
Messages
7
Good day to you excel gurus. I'm still a newbie and learning the magic of VBA. (i really hope i can be as good as you guys one day)

So anyway back to the topic!.. I am working on a code and i'm stuck at this part. What i want the code to do is to load and navigate through a website. Let say the website is (http://www.website.com/console.html) and contains a horizontal toolbar with "Menu", "Search" & "Download". The "Menu" page will be the default page that shows up upon accessing the link. (I'm only able to code till this point and am stuck with the following.)

What i want the code to do is to click on the "Search" button. However, I cannot link directly to the search page like simply specifying a direct HTML link eg.(http://www.../search.html). A right click > properties in IE shows that the path leading to the "Search" page is something like (http://www.website.com/jsp/search.jsp). I have tried direct linking the page to the 'search.jsp' link but the horizontal toolbar will not be showing. This becomes a problem for me as i cannot select any other options like "Download" on the toolbar. (I know there is a name for such a javascript design but i dont know what's the name of it haha)

I dont have the website to share because its an intranet site and i have no access to it on my personal computer. Nonetheless, im still trying to learn (but i couldn't find any website of such designs; any recommendations for me to use to debug now would greatly be appreciated too!)

Will require your professional help in helping me solve this issue. Thanks awesome community!
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

AppleZapple

New Member
Joined
Feb 29, 2016
Messages
7
Sorry, forgot to add my code in. This is what I have for now.

Sub OpenWebpage()
Dim ie As Object
Set ie = CreateObject("Internetexplorer.Application")
ie.Visible = True
'a random webpage i have inserted
ie.navigate "http://btemplates.com/2016/blogger-template-limousine/demo/"
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,122,463
Messages
5,596,284
Members
414,051
Latest member
tabecker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top