LinkBack URL
About LinkBacks
I would greatly appreciate assistance in helping debug this piece of code and get it to run properly in VBA excel 2016.
VBA macro issues (Extract data from password protected website to excel)
I would greatly appreciate assistance in helping debug this piece of code and get it to run properly in VBA excel 2016.
I once did something like this. i added the code below.
Its hard to help you debug when we dont have acces to the site.
where does it go wrong?
Edit: i forgot the functions... everything was put in the same module btw.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by 323428; 11-09-2018 at 11:42 AM.
Do you actually have the password for that site?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I do have a password for the site.
I can't give it out. It is very sensitive.
Is it possible to resolve it without password info?
Just to help us, add a dummy PW, which you can then replace with the real password
In the attached .txt file I have provided comments where things go wrong.
Program terminates in these lines:
Dim clip As DataObject 'Program stops in here
Do While ieApp.Busy: DoEvents: Loop 'Program stops in here
Do Until ieApp.readyState = READYSTATE_COMPLETE: DoEvents: Loop 'Program stops in here
Set ieDoc = ieApp.document 'Program stops in here
I would appreciate a little bit more explanations about two pieces of code you have posted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks