There are several ways. My personal favorite is Repeat -> Until When coding automation for something such as making Facebook accounts and liking a specific page, would you recommend doing so with Point Click Copy automation and repetition or do you have a quicker method? Is it possible to PutClipbo...

Hmmm not sure as it works fine for me.

Is the data in the cells D7:D30 formatted as per your original post? (00:00:00 time format)?

Syntax error on the line that increments the count value - should've been Let>Count=Count+1 Try this : //Play With Time XLOpen>C:\Paul_PlayMacros\Time.xlsx,1,xlBook Let>Count=7 Repeat>Count XLGetCell>xlBook,Sheet1,%Count%,4,TimeValue VBEval>FormatDateTime(%TimeValue%,3),FormattedTime If>TimeValue=0 ...

Ah ok - so if you do your standard image recognition you get something like this : FindImagePos>%BMP_DIR%\image_1.bmp,A Window you've selected from the wizard,0.7,1,XArr,YArr,NumFound,CCOEFF If>NumFound>0 MouseMove>XArr_0,YArr_0 LClick Endif This will click the exact middle of the image_1.bmp when i...

It's no problem - I've had plenty of help out of the forum so it's nice to be able to put a bit back. In an instance where I have multiple very similar issues I've sometimes expanded the needle image to include some small detail either side of the main image in order to make that image unique from t...

Ah I see your logic now. I would still recommend just using the image recognition wizard and not bothering to section off a bit of the screen - the screen recognition for a specific window is quite fast anyway :wink: I can't help you with the specific error but if you raise a ticket with the support...

That would never time out though if the image never appeared. It was JRL who came up with it in response to an issue I was having where a website wouldn't load timeously if I used the waitscreenimage command in the manner you should (it appeared to interrupt the page loading). Details here: http://...

I haven't used that command but reading the notes it stores it at the path location AND in the clipboard. Somebody more technically inclined would be better placed to answer your question but I'm guessing this is probably an issue with memory or maybe even a full drive/location that has no room to s...

I've had problems with timings before (primarily with websites) and this snippet of code that was offered up on the forums here proved to be a Godsend in avoiding using overly long waits to compensate. Let>WSI_TIMEOUT=1 Label>WaitingForImage2 WaitScreenImage>%BMP_DIR%\image_001.bmp,0.7,CCOEFF If>WSI...

I'm getting this error ("Branching out of subroutine is not recommended and may result in memory loss...") also on Line 163 of my macro. Here is line 163. Goto>StartMainLoop The error cannot mean what it says because line 163 is NOT in a SRT. :( I've had this one before - are you sure that line 163...

Hi teyoh, I *think* I've understood your requirement - this code will look for one of the first 4 images and once it finds any one of them it will skip to look for the 5th image. The use of Goto and Label are key and probably what you're needing to do what you want. In this example I used the wizard...

I think it might be related to you grabbing a screencapture then using it as your haystack image (this is stored in the clipboard as well - if you are going down that route you might want to put a WaitClipboard in front of the ScreenCapture command. I always use the default locations offered by the ...

aaaaand once again I post it then the answer hits me right in the face :

Let>LeadsDateTime={("'"+%LeadsDateTime%+"'")}

Missing quotes on the variable

Hello, I'm trying to query an external SQL database and return a subset of data based on the fact it is data that was generated in the last twenty minutes. I can return data and get most SQL queries to work but for some reason I can't get this to do what I want. I construct the date/time and store i...

Hi John, Is this what you're after? It changes the cell then returns it to the spreadsheet overwriting the 00:00:00 format version. Hope it helps, Paul. XLOpen>C:\Paul_PlayMacros\Time.xlsx,1,xlBook XLGetSheetDims>xlBook,Sheet1,nRows,nCols Let>Count=1 Repeat>Count XLGetCell>xlBook,Sheet1,%Count%,1,Ti...