Object Variable or with block variable not set ERROR in VBA

Instead of creating an Internet Explorer object, you'd better make a form with a web browser object, and catch the DocumentComplete event.

There is an article on MSDN:
https://support.microsoft.com/en-us/help/180366/how-to-determine-when-a-page-is-done-loading-in-webbrowser-control

Fabrice,

thanks, but led me on a wild-goose chase.  i cannot debug the code which i have and yet, how would i use the information on the link you shared.

i cannot debug the code which i have...

Do you mean that you don't know how?

martin

i am not good at VBA.

currently my code shown in my OP. has an error. i do not know what it occurs and how to fix it.

thanks.