I do have but different computers, their Excel behave differently. Like I just tried my macro in excel on my colleague's computer to run Attachmate, it just hanged there while mine was running smoothly.
Was advised by my IT dept to run the macro via Attachmate instead.
So..... can I check how...
Apparently I have tried running the lookup with Excel on my colleagues' computer but it didn't run well.
So looking at using text file as alternative.
Now waiting for the files to be sent to me for trying..
:D
Hi,
Okay..
I can't show you what's on my attachmate screen due to sensitive information.
1. I will key in a "Register number" to process the entry.
2. After which I will cross reference Field 52 (11, 62) (Eg. BOFUSESS) with sample 1 database.
2a. If YES, proceed with cross referencing with...
Hi,
Will there by any speed difference when accessing excel or text file? If not I also believe excel will be a better choice in organizing the list.
will be doing string comparison in SEBIS with the file sample 1, if found matching string will go ahead to open file sample 2 to look for same...
Next question!
How do I read external files? (Eg. txt file)
sample 1
to scan sample 1 2nd column data downwards with a variable to match string
sample 2
if found matching string.. in sample 2, copy the string after delimiter ':'
and put into a variable
can it be done?
BR
kzhkr...
Haha.. Okay, this is my full working code.
'--------------------------------------------------------------------------------
' This macro was created by the Macro Recorder.
' Session Document: "C:\Users\S90103\Desktop\sebis_HK.edp"
' User: S90103 - 20190117...
Ehh.. Actually till now even after I removed <F13> on the code before that, Sess0.Screen.PutString ("HK" & mtrnID, 4, 5) still is syntax error.
The beetle will be removed if I put it as Sess0.Screen.PutString ("HK" & mtrnID), 4, 5
and yup, it will load that field where the cursor is.
Yup, that's right. So unless my cursor is there, it will not input anything. (Eg. My cursor is currently at 3,13, the string will be put at 3,13 instead of 4,5)
Is there any setting to disable/enable for the string to be place anywhere in the screen and not based on where the cursor is?
Removed the <F13> also still have the syntax error.
And tried using the code in the example you linked, it will only PutString "Hello" on the line my cursor is.
It won't specifically go to the coordinates I assigned.
Ehh... Means after every <Enter>, <Tab> , <F13> etc I have to do a WaitForCursor Loop? [spin2]
F13 is a command for clearing field so I think it's unavoidable and F13 should be instantaneous.
So... correct me if I'm wrong. I can actually use PutString without doing any tabbing in the screen?
Sub Main()
Dim mtrnStart As Long
Dim reaCode As Long
Dim mtrnID As String
Dim crDate As String
Dim crDate2 As String
Dim remitID As String
Dim crAcct As String
Dim valDate As String
Dim valDate2 As String
DisableKeystrokeProductivity = True...
Understood. But maybe I missed out an important point..
The tabbings are for me to input data into the fields
and will execute the codes in Attachmate itself.
Thanks
kzhkr
So.. my DoEvents is to tab through the field until the cursor rest on (23, 9) but everytime it overshot it.
And MoveTo does not work on my EXTRA! attachmate, is there alternative method to tab to specific coordinates if WaitForCursor does not work with <tab>?
Thanks
kzhkr
Hello,
Not sure if it's a norm to create different threads for different questions but thought I would consolidate my queries under this thread.
Q1. WaitForCursor
would like to check for this 2 codes below
Sess0.Screen.SendKeys ("<Enter>")
Do Until...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.