|
-
Jan 17th, 2012, 12:30 PM
#1
Thread Starter
Hyperactive Member
[RESOLVED] Getting Web Page data into Excel
I'm using the code below to go to a web page, copy all of the data and paste to clipboard. The web page, when first opened, has its focus set on a field that is expecting user input. So, when I paste what's in the clipboard into Excel, I get "Enter a name or symbol", which is the field's solicitation. How can I skip, unfocus, or otherwise get around this solicitation, so that when I 'copy all' I in fact get the entire web page and not the field solicitation? Thanks.
HTML Code:
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = True
.Navigate (url)
Do Until .ReadyState = 4: DoEvents: Loop
.ExecWB 17, 0 '// SelectAll
.ExecWB 12, 2 '// Copy selection
.Quit
End With
ActiveSheet.Paste
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|