read text from open programs

[MJB3K]

Hi, i have a question. How can i grab the text from open programs.

e.g. grab some text from IE explorer, or Word for example.

I will then write a filter for the text brought in and if it has any inappropiate languages, take a screenshot of the page.

Is this possible??

Any ideas??

Regards,

Martin

Computing Help And Info:

http://www.webrevolt.biz

 

[Chance1234]

Dont think VBA is going to be your answer.



Chance,

Filmmaker, taken gentleman and [insert quote here]

 

[Simmy]

Hi MJB
Found this code in one of my modules, you will need to cahnge the web addres & probably some other stuff but it may give you some ideas

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;

http://www.tek-tips.com/viewthread.cfm?qid=1175935&page=1",

Destination _
:=Range("A1"))
.Name = "viewthread.cfm?qid=1175935&page=1"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.Refresh BackgroundQuery:=False
End With
Application.CommandBars("External Data").Visible = False