TinyTerm, WDS-II and Excel VBA
WDS-II is the acounting software written on top of a Progres 4GL
database. I have no control over how the output comes - my MIS
department determines that. As I understand it, Samba runs on the UNIX
box and allows my windows pc to use it as if it was a windows drive. If
that's true, then I have no way to make that happen. If that's not
true, then Samba is way over my head. Either way, I want and excel
routine to send a few keystrokes through TinyTerm to the accounting
system, to make it spit out the reports I need. I would then use Excel
to control the FTP program to move the reports to where I could get at
them. I already have Excel routines that suck up the reports and
massage them into tables that I can then use for financial analysis.
This all may sound kind of like using a guitar to swat a fly, but I
know Excel better than any other computer program and that is why I am
trying to use it to do things it may not have been meant for.
|