Green screen scrape

[Nick]

Hello

Can anyone give me any pointers as to how I can program excel to perform a
screen scrape from a 'green screen'?

Many thanks and kind regards, Nick

 

[Ron Coderre]

Wow! I haven't had to do an actual "screen scrape" in around 15 years.
Back then, the mainframe general ledger had a scripting language (SISL
Script, as I recall) that could do the "scraping". Since it used DDE, I could
use it as a DDE server to engage Excel as a DDE client. Then I could pass
information back and forth. I don't know if Excel has subsequently obtained
the ability to engage the screen of non-windows application. You may need to
check if your application has its own script language.

I hope that helps.
***********
Regards,
Ron

XL2002, WinXP

 

[Nick]

Many thanks for the info Ron.

Please pardon my ignorance.

I have an Access database with code that performs a similiar screen scrape
to the one I'm trying to code in Excel (someone wrote this for me as a favor).

I thought if it can be done with Visual Basic into an Access database- then
it can also be done with Visual basic into an Excel spreadsheet.

Is this assumption wrong?

Many thanks again and kind regards, Nick

 

[Ron Coderre]

You said "green screen scrape". "green screens" mostly exist for DOS or
non-windows, mainframe applications, any more. I guessed that you were
working with one of those sources. If that's not true, please give us more
details about what you wnat to do.

***********
Regards,
Ron

XL2002, WinXP

 

[Nick]

I'm sorry for the confusion.

I work for a finance firm, and I'm putting together a scanner that can read
data from our internal 'mainframe' systems (as we refer to them).

I'm trying to scrape data from this CDN session.

Does that make it any clearer?

I really appreciate your input.

Many thanks and kind regards, Nick

 

[Tim]

Your Access code would be the best place to start - it can likely be easily
modified to run in Excel.

Tim