Search results for query: *

Global is a valid variable type in VBA, Skip - it's pretty much synonymous with Public. Incidentally, I tried adding the Attachmate object libraries within Excel to see if that helped : Public MySystem As ExtraSystem Public MySession As ExtraSession Public MyScreen As ExtraScreen It didn't...

Pretty sure - that's why I went to the trouble of using a fully qualified file name / path (to avoid the situation of different users having the same network drive mapped to different letters on their workstations etc.) But to eradicate that 0.1% of doubt, I'll go and test it on one of the...

Thanks Skip! Just to clarify, this code is running from Excel VBA (within the workbook that will reference the session) And the stEDPFile string is the fully qualified path and filename of the pre-configured session (i.e. "\\server\folder\session.edp") - which the users have full visibility to...

Hi guys, I've developed a macro in Excel 2007 to read/write to a pre-configured Attachmate session (the path for which is described by a string variable, stEDPFile). The macro is designed, on opening the workbook, to check if this session is already open, and if not, to open it : Global...