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!

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

Recent content by kzhkr

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

Part and Inventory Search

Back
Top