Relative screen coordinates. How to extract them from an Excel workbook?

[NackJich]

Hi there.. I have attached my workbook, but below is essentially what there is to see. What i am hoping to do perhaps with a standalone script is to strip away the sleeps and the commas and the zeros and then compute the difference between each two sets of values in turn. They are screen coordinates and I'm intending to use them in a macro. Wonder if someone could point me to how? I can manually find/replace and I can possibly create formulae on my spreadsheet, but since the excel page will always be in the same format it lends itself to some sort of scripting (of which i know zilch). Thank you !!

Sleep, 32 INTENDED RESULT 0 1
Click, 326, 351, 0 -1 0
Sleep, 375 0 1
Click, 326, 352, 0 -1 1
Sleep, 15 -1 0
Click, 325, 352, 0 and so on
Sleep, 16
Click, 325, 353, 0
Sleep, 31
Click, 324, 354, 0
Sleep, 16
Click, 323, 354, 0
Sleep, 15

[BadlySpelledBuoy]

Perhaps this will help.. At least I think this is what you mean from the description of the problem.

Please Login or Register  to view this content.

Open the attached and click the button to run the code.

BSB

[NackJich]

Thanks BSB. That worked very well. Just the job thank you. Now I have to work out how to get those values into my macro !!

[mjr veverka]

... strip away the sleeps and the commas and the zeros and then compute the difference between each two sets of values in turn ...

... try:

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Thanks BSB. That worked very well. Just the job thank you. Now I have to work out how to get those values into my macro !!

Happy to help.

What is the macro you have that these are to feed into?

BSB

[NackJich]

The current macro is a Autohotkey program that reads a txt file. I wanted to make the values relative rather than absolute which is why I am trying this in Excel. The AHK script will have to be modified of course. Is it possible to export those two columns to a .txt file? I'm sure there must be a better way. Thanks for your help.
This is the AHK code:

Please Login or Register  to view this content.

[mjr veverka]

1. Maybe at all load a text file to the memory and after processing (excel macro) copy it back to the "txt" file ?
2. What about the last line of the coordinates, which are not calculated ?