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.
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.
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:
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.