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 Chriss Miller 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 smiler44

  1. smiler44

    Attachmate on one lap top with multiple users

    we have a laptop that we would like to be able to share when needed with different users. ne day one person could use it, another day a different person. This does not seem to be a problem with Microsoft products on the laptop but Attachmate will not work. Each user looks on as themselves as...
  2. smiler44

    how to compare

    skip i also read the extra help on dateserial. i did not understand it most of my stuff "does not require" excel as i dont have any reason to interact with it. to ask users to open excel to run a macro in attachmate when they hve no data to be used from or entered into excel, i dont go with...
  3. smiler44

    how to compare

    skip I have tried your code and can see that it gets the last working day of the month. I think it uses Monday to friday as the working week which is fine. i can not work out how to modifiy the function to give me the next working day's date after today not matter what day today is. could you...
  4. smiler44

    how to compare

    skip I agree vba is better but does that not then involve using two programmes, Excel and attachamate? using two programs would not be very smooth. I have looked at the link you sent me and copied some of the code to try. appreciate the help. smiler44
  5. smiler44

    how to compare

    skip, thank you but I don't understand fully. I get the text and number part. I have come up with a way, may be long winded but this is how I've done it: scraped data/date = 25/12/13 todays date = 05/01/14 I compare the 13 to the 14. 14 is greater, no more checks use the 05/01/14 date if 13...
  6. smiler44

    how to compare

    minds gone blank. I have scraped some text from my screen 22/12/13 and want to compare it to todays date. todays date will change day by day and so will the text I scrape from my screen. how to I compare the two to see if the date (text) I have scraped from by screen is less than todays date...
  7. smiler44

    declare variable so can be uased as

    found out it is best not to declare a variable as integer but long. I have now changed by variables from integers to long, this seems to have solved the problem smiler44
  8. smiler44

    declare variable so can be uased as

    my customer orders all have varying number of pages, can be over 200 page or as little as 30. the macro is for the user to enter a word at the top of the screen that they wish to find in the 200 or so pages. the macro starts at the last page and works to page 1. if it finds a match it notes the...
  9. smiler44

    declare variable so can be uased as

    I have been told that to convert a string to integer it is dim firstvariable as string dim secondvariable as integer firstvariable = "12" secondvariable = val(firstvariable) although I still have the problem already mentioned, my number 218 stored seems to go from the number 218 and changes...
  10. smiler44

    declare variable so can be uased as

    Skip, I replaced firstfound = newp with firstfound = trim(Sess0.Screen.GetString(9, 64, 3)) but get a complie error. I'm going to try do do the conversion in the prepair routine instead of the main routine, see if that makes any difference. smiler44 The compile error problem may be because...
  11. smiler44

    declare variable so can be uased as

    [blush] I'm not trained and finding reading material for attachmate is not as easy as finding stuff for Excel. Array, think I've seen one once, no idea how it worked this is where it goes wrong stepping through the code, when it steps past the line of code secondfound = newp for some reason...
  12. smiler44

    declare variable so can be uased as

    I have stepped through the code. newpp = "218" newppp = 218 and newp = 218 My user wants to look through all the pages of notes to find a word. They type the required word at the top of the screen. The macro captures the word, works out how many pages there are and then starting at the last...
  13. smiler44

    declare variable so can be uased as

    this is how I have tried to convert a string to integer Sess0.Screen.GetString(9, 64, 3) gets 218 from the screen. when I stop trough the code and move off of newp = newppp newp changes from 218 to 14287066??? No idea what's going wrong smiler44 my code is Global declarations dim newpp as...
  14. smiler44

    declare variable so can be uased as

    skip, i'll post over the weekend. have shut laptop down now but please.... watch this space smiler44
  15. smiler44

    declare variable so can be uased as

    I'm not sure if my method of going from string to variant to integer works. I'm using nameofstring = Sess0.screen.Getstring(9, 12, 3) my string is the "number" 218 but the integer is 14287066 I seem to recall integers are a bit funny but can you help? thanks smiler44
See more

Part and Inventory Search

Back
Top