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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kzhkr
  • Order by date
  1. kzhkr

    Questions!

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

    Questions!

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

    Questions!

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

    Questions!

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

    Questions!

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

    Questions!

    Haha, alright. Good night! :)
  7. kzhkr

    Questions!

    Which code?
  8. kzhkr

    Questions!

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

    Questions!

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

    Questions!

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

    Questions!

    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?
  12. kzhkr

    Questions!

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

    Questions!

    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?
  14. kzhkr

    Questions!

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

    Questions!

    There is syntax error..
  16. kzhkr

    Questions!

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

    Questions!

    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?
  18. kzhkr

    Questions!

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

    Questions!

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

    Questions!

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

Part and Inventory Search

Back
Top