Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

reflections 2011 excel

reflections 2011 excel

reflections 2011 excel

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

RE: reflections 2011 excel

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.


glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: reflections 2011 excel

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.

RE: reflections 2011 excel


there is no 'help' in reflections
Please explain where you found this 'help.'  

Is there a web site link?


glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: reflections 2011 excel

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


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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close