• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to redirect to subsite on webpage

HeenaS

New Member
Hi there,
I need help to redirect to subsite of a url via macro..
eq. lets suppose https://www.flipkart.com is main site to which macro should login first and then after successful login it shoul direct to https://www.flipkart.com/mobiles-big-shopping-days-2k19-5s29-store

I tried providing subsite url in vba but after login it get refreshes and returns to main page itself...

Code:
Private Sub CommandButton1_Click()
Dim IE As String
'Dim IE2 As String
   IE = """C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"""
   Shell (IE & " -url https://www.flipkart.com")
   Shell (IE & " -url https://www.flipkart.com/mobiles-big-shopping-days-2k19-5s29-store")
End Sub
 
Last edited by a moderator:

Logit

Active Member
.
Running your code here, as is without any changes, produces the results you are seeking. First the main page of the website opens, then
the sub-page opens over top of the main page.

????
 

HeenaS

New Member
ye
.
Running your code here, as is without any changes, produces the results you are seeking. First the main page of the website opens, then
the sub-page opens over top of the main page.

????
yes but it is opening in 2 different tabs... I want VBA to click on specific category and drop down option on main page
 
Top