Hi,
I have the below which logs me into the website I want succesfully. However, once I am logged in I want to navigate to another page to which I have provided the link for. However, the macro just sits on the page you get after I log in. Have I done something wrong in the code?
Please Login or Register to view this content.
try changing
ieApp.navigate
to
objIE.navigate
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
Thanks Sean but still not working. Another way would be to open a new tab and browse to the url. Is that possible?
Or how would I change the loop's as I think that is what may be causing it. I think it might be trying to go to the page I want before fully logged in?
no because you wont be logged in using a new tab.
What is actually happening?
have you checked the code is entering your user name & password before submitting.
If so, when you are logged in does the web page show you are logged in?
Yep, I've checked and it is entering my username and password and logging me in fine.
If I remove
then everything works as should be. But I obviously need this bit to now go to the page that I want since I am logged in.Please Login or Register to view this content.
i usually use something like this after btnSubmit.Click
Please Login or Register to view this content.
this code basically waits until the page is fully loaded after submitting your username etc to allow the page to log you in.
Then it redirects the IE to your next page
then it waits until it is fully loaded.
Check your website address, i couldnt even access it.
change this bit
toPlease Login or Register to view this content.
you havent assigned ieApp, you are using objIEPlease Login or Register to view this content.
Thanks, have it working now.
Last thing....how do I then copy the entire page that loads and paste it into my excel workbook?
I've searched around and came across this, but it doesn't work
Please Login or Register to view this content.
try something like this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks