Excel VBA: Moving from Extra! to Reflection 2008 1

[rgm33]

Hi,

Could somebody provide the equivalent code to establish a connection from Excel to Reflection 2008.

Public System As ExtraSystem
Public Sessions As ExtraSessions
Public Sess0 As ExtraSession
Public MyScn As ExtraScreen

Set System = New ExtraSystem
Set Sessions = System.Sessions
Set Sess0 = System.ActiveSession
Set MyScn = Sess0.Screen

Thanks!

 

[SkipVought]

This maybe?

http://support.attachmate.com/techdocs/2183.html

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[rgm33]

I found the solution under:

http://support.attachmate.com/techdocs/2209.html

Set a reference to EXTRACOM and remove the reference from the old Attachmate Library. In my case it was ATTACHMATE EXTRA! 7.1 Object Library. It should show as MISSING in the reference list. Very important to remove the missing reference. Before I removed it, the built in VBA functions like Right(), Left() & Trim() would not work.

After setting and removing references, make these changes to the code.

Public System As EXTRACOM.ExtraSystem
Public Sessions As EXTRACOM.ExtraSessions
Public Sess0 As EXTRACOM.ExtraSession
Public MyScn As EXTRACOM.ExtraScreen

Set System = New EXTRACOM.ExtraSystem
Set Sessions = System.Sessions
Set Sess0 = System.ActiveSession
Set MyScn = Sess0.Screen