K
ker_01
I'm trying to use VBA to capture web page content from an open instance of an
IE browser that has already been directed to the target page. I've elected
not to access the URL directly from Excel because there are several pages of
user selections that produce the page I actually want to capture (which is a
dynamic report). I am successfully accessing the open IE6 instance and
grabbing content.
Right now I'm trying variations of the following to grab the page contents
Set rng = objIE.document.body.CreateTextRange
strPageHTML = rng.Text
but what I'd really like is the full page source (if possible) and
intellisense isn't giving me any prompts after rng.
Can anyone point me to the proper object model that gives the different
range options to capture different parts of the page, like innerHTML or
"all"? Preferably a reference that also explains what each option is, since
I'm unfamiliar with HTML coding.
Thank you!
Keith
IE browser that has already been directed to the target page. I've elected
not to access the URL directly from Excel because there are several pages of
user selections that produce the page I actually want to capture (which is a
dynamic report). I am successfully accessing the open IE6 instance and
grabbing content.
Right now I'm trying variations of the following to grab the page contents
Set rng = objIE.document.body.CreateTextRange
strPageHTML = rng.Text
but what I'd really like is the full page source (if possible) and
intellisense isn't giving me any prompts after rng.
Can anyone point me to the proper object model that gives the different
range options to capture different parts of the page, like innerHTML or
"all"? Preferably a reference that also explains what each option is, since
I'm unfamiliar with HTML coding.
Thank you!
Keith