reflections 2011 excel

[lawrenceone]

using excel and vba i want to screen scrape using reflections 2011
cany anyone tell me the code to dim the reflection object and set the screen object
i have used extra and no problem but things are different in reflections 2011 and there is no useful help on the attachmate site
any help would be gretly appreciated

 

[SkipVought]

Of course, there would be no help in Attachmate for some other application!

You must look in THAT application's VBA Help in order to find help on THAT application's objects, properties & methods.

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

 

[lawrenceone]

I am not looking for Excel vba help but rather how excel vba
establishes attachmate reflections as objects. there is no help in reflections on how to write code in excel vba, but once references have been established in excel vba, then I am
looking for the code that vba would use to reference the attachmate reflections objects in excel vba in the same way it would attachmate extra objects.
hope this better explains the situation.

 

[SkipVought]

there is no 'help' in reflections

Please explain where you found this 'help.'

Is there a web site link?

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

 

[rgm33]

This might help you. I don't know about using Reflection objects but this is what got my old scripts working under Reflection.

My old Extra! scripts were set up like this:

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

They didn't work after the upgrade to Reflection.

This article at Attachmate explained where to make changes

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