I’ve have number of automation scripts (written in Ruby but I think this question could apply to other languages) that use Win32OLE interface to connect to MS Office, BlueZone (Mainframe emulator) etc.