I'd like to be able to have excel scrape text from an active window
while I'm surfing. I can currently import a picture, but would prefer
the text.

I do a snapshot using the following code:

Public Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal
bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
Public Const VK_SNAPSHOT = &H2C
Public Const KEYEVENTF_KEYUP = &H2


Sub screenshot()

For i = 1 To 10000
For j = 1 To 10000
Next
Next
keybd_event VK_SNAPSHOT, 1, 0, 0
Range("a5").Select
ActiveSheet.Paste

Application.ScreenUpdating = True

End Sub

The reason for the loop is to give me time to click on the desired
window after I start the macro.

My thinking is there is a possibility that

keybd_event VK_SNAPSHOT, 1, 0, 0

Could be changed to scrape the text instead of the snapshot.

I understand a website can be scraped, but prefer not to do it this
way. And I know I can hit control A, control C and control V in the
spreasheet, but prefer not to do it that way.

Thanks,

Geoffrey Pritchard Tillingsley