×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!
  • Students Click Here

*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

Jobs

Excel 2010 not responding when making connection to myExtra Enterprise

Excel 2010 not responding when making connection to myExtra Enterprise

Excel 2010 not responding when making connection to myExtra Enterprise

(OP)
Dear all,

I have been looking for a solution for weeks, but really cant seem to find one. I hope you guys can help.

The place where I work currently uses Windows XP with Exel 2003/2007.(I know its old, but the company takes its time).
Now there is a migration proces to go to Windows 7 with Excel 2010.

There is a test environment where we tested the file to make sure it works, but it doesn't. We also tested on a laptop that has been migrated to Windows 7 with Excel 2010, but also here it failed.

I have tested different versions of the code and also with the library on, but it keeps running into the same problem. No error or whatever, but Excel says (not responding). After a while it askes to shut down and reboot.

Here is the code of the function we use to test if there is a connection between Excel and myExtra Enterprice AttachMate.

CODE --> VBA

Function test()

Dim System ' Attachmate System
Dim Session ' Current Host Session
Dim Screen ' Current Screen
Dim milliseconds ' milliseconds to wait
Dim Rows ' Rows in Current Screen
Dim Cols ' Cols in one Row
Dim Row ' Row Counter
Dim Buffer ' Buffer to hold Screen Image
Dim Line ' One Line
Dim Lines ' All Lines belimited by vbCrLf
milliseconds = 100 ' 1000=1 second
Set System = CreateObject("Extra.System")
If System Is Nothing Then
    MsgBox "Could not create the System Object", _
                     vbOKOnly + vbCritical, "Get Screen"
    Exit Function
End If

Set Session = System.ActiveSession
If Session Is Nothing Then
    MsgBox "Could not create the Session Object", _
                    vbOKOnly + vbCritical, "Get Screen"
    Exit Function
End If

End Function 

I have also done the step by step thing and then it stops add different lines. I can see it makes a connection because the variable System changes from 0 to "myExtra" or something like that.

When I push F8 quickly it will go further then when I take pauses after each line.

I think this is all I can think of for now as information.

If you have any ideas/ suggestions, please let me know.

RE: Excel 2010 not responding when making connection to myExtra Enterprise

Hi,

I'm confused! I don't see ANYTHING in your code example regarding Excel???

Does your code run from Excel VBA?

I don't know what you're asking???

RE: Excel 2010 not responding when making connection to myExtra Enterprise

Hello,

Maybe try with this one

CODE --> vba

Sub RapidBalances()
Dim Sys As Object, Sess As Object, Screen As Object
Dim i As Integer
    Set Sys = CreateObject("EXTRA.System")
If sys Is Nothing Then
        MsgBox ("Could not create Extra.System...is it installed on this machine?")
        Exit Sub
    End If



' Assumes an open session
    Set Sess = Sys.ActiveSession
        Set Screen = Sess.Screen

Set Sess = Nothing
Set Sys = Nothing
Set Sess = Nothing

End Sub 

RE: Excel 2010 not responding when making connection to myExtra Enterprise

(OP)
Thanks for the replies.

@SkipVought Yes this code is run from Excel VBA

@Tommeck37 I will try in the next couple of days. Thanks.

RE: Excel 2010 not responding when making connection to myExtra Enterprise



Do you have a session open in Extra when you run this code in Excel VBA?

RE: Excel 2010 not responding when making connection to myExtra Enterprise

(OP)
@SkipVought Yes the session is open when I run the code.

RE: Excel 2010 not responding when making connection to myExtra Enterprise

give this a try for your declarations

CODE

Dim System As Object ' Attachmate System
    Dim Session  As Object ' Current Host Session
    Dim Screen As Object ' Current 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