Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Attachmate 2011 reflection vba Macro Help

Status
Not open for further replies.

Cryogenic666

Technical User
Jun 27, 2014
1
SE
Hi, everyone

I'v got an issue with a VBa macro I've Been writig for a couple of days now.
I would like to check on the terminal screen if there is any data a certian row, and if there is give the user
a message box with two choises overwrite or skip.

The problem is when I try to run the code I get an error:

Run-Time error '438': Object doesn't support this property and method and debug points towards an If statment (See code below)

Dim A As Variant
A = osCurrentScreen.GetCharacters(9, 20, 1)
'MsgBox (A)

If A(0) = 0 Then
Dim msg, style, title, ctxt, response, MyString
msg = "Befintlig data i givare " & gNum & " Skriva över?"
style = vbYesNo + vbCritical + vbDefaultButton2
title = "Fel i givare " & gNum

response = MsgBox(msg, style, title)
If response = vbNo Then GoTo Line1
End If

I would appreciate any help and if you can't find a solution I would also like suggestions for other solutoions. :)
 
Hi,

You variable A is NOT an array!

Also, the data type returned by GetCharacters is TEXT!

Code:
If A = "0" Then

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top