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 IamaSherpa 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: rebie
  • Order by date
  1. rebie

    Using VBA to write scripts.

    Here's as simplest as I got right now... Thanks much. '-------------------------------------------------------------------------------- ' This macro was created by the Macro Recorder. ' Session Document: "C:\Program Files\Attachmate\E!E2K\Sessions\KPNW\Bluegate.EDP" ' Date: Monday, January 29...
  2. rebie

    Using VBA to write scripts.

    OK, I think I'd like to start using VBA to create my Attachmate scripts, but I'm a little lost in getting started. I've read calculus' FAQ "How do I use VB(A) to manipulate attachmate (6.5+)? FAQ99-4069", but there's not enough context there to help me. Where do these statements go? Inside...
  3. rebie

    Force Saving an Excel file

    Bingo again! Thanks.
  4. rebie

    Force Saving an Excel file

    OK, so the more I get into this, the fancier I'm trying to make things...[bigsmile] So in my script I cycle through a list of potential member numbers from an Excel file. If a number comes up as already in use, I write the member's name in the cell adjoining the number. This works fine. At...
  5. rebie

    Null a String variable

    Bingo! Thank you very much, MrMilson.
  6. rebie

    Null a String variable

    Here's the code: ' Declare the Excel Object Dim appExcel As Object Dim wbExcel As Object Dim aSheet As Object Set AppExcel = CreateObject("Excel.Application") Set wbExcel = AppExcel.WorkBooks.Open("p:/CM_Members.xls") Set aSheet =...
  7. rebie

    Null a String variable

    Hi, I'm using a string variable as an error condition check (based on the presence of random alphanumeric characters on a certain part of the screen) and need to set the value back to null or empty before going through a loop again. But I can't get it to work. Using the Null function as shown...
  8. rebie

    Input id numbers from Excel using Extra script

    Thank you, Mr.Milson. This did it. -rebie
  9. rebie

    Input id numbers from Excel using Extra script

    Hello All, I have been browsing similar threads about this topic, put I just can't seem to put it all together. And what I need I think is farily simple for you gurus. I have a list of member id numbers in a spreadsheet, starting in Column 1, Row 1 and going up to Row n. It will always only...

Part and Inventory Search

Back
Top