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!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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
 
Upvote 0

Forum statistics

Threads
1,223,238
Messages
6,170,939
Members
452,368
Latest member
jayp2104

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
Back
Top