Thank you both for your help.
I tried both "waiting-statements" (as well as my old one) but vba still gives me the error.(failure 8010040)
Even activating the HTML Object library didnt work?
Sub scanner()
myUrl = "http://dict.leo.org/frde"
Set IEApp =...
hi there,
a couple weeks ago i postet a question about loading IE-Content into Excel.
My problem is now, that it doesnt load the content into the dashboard since the browser is not fully loaded. (failure 8010040)
When googeling for help I always found a codeline called DocumentComplete which...
hi there,
thanks for your reply.
My code is the following and I am pretty sure, that I am right in front of the goal.
...but for now, it still doesnt work?
He opens the website, enters the word correctly, sends the keys, and again opens the appropriate site ... but then: unfortunately there...
yes exactly, but the text is dispersed over tables and I just want to copy the whole thing into excel and there I already know how to scan through the cells and look for the right entry.
thanks for your help, even though this statement was already given in the post ... I must be honest, that I...
but i think, what i am looking for is easier to achieve, since i i only need the statement that copies the whole screen into excel.
it's the same, as when i visit a page, press "mark everything/ mark all" and copy it into excel
does anybody know the vba-statement to reasize that?
thanks
hi there,
i have a small code, which helps me to access a website.
now i only want the internet explorer to copy a word from the text and save it into a variable.
the code so far:
Sub scanner()
myUrl = "http://www.awebsitexyz01826.com/whatever"
Set IEApp =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.