Search results for query: *

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, alright. Good night! :)

Which code?

it still input onto my cursor instead of the coordinates specified.

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?

Sorry, I have to blank out some details. The error is only "syntax error

There is syntax error..

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

It doesn't work unless my cursor is at that field. If it should work, is there any settings I have to do in order for it to work?

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