Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Skip this is the weakest excuse you will hear but is true. I broke my glasses and my screen is to small to read without glasses. should get new pair this week and so can try it then. smiler44

Variant, thank you Skip. Could you give me some more advice? Is it possible to get a number that is stored in a variable that has been declared as a string to be reconized in another variable as a number by going something like dim firstvar as string dim secndvar as variant dim thiordvar as...

is it possible to declare a variable so it can hold text or number? I thought "dim variablename as variable" would work but it seems not? thank you smiler44

Lakare, I'm sure I did but will go and try again just in case. smiler44

Skip thank you. Already done and it works a treat. smiler44