AutoHotkey Community

mjgfhy1 wrote:I'm a novice, got started by downloading Pulover and watching the tutorial videos. So far I have been able to accomplish everything I am looking for. Pulls #s from an excel file, works down a column, inputs the #s in another program. I'm having a hard time getting it to break the loop/stop once it reaches a blank or empty cell. I am not familiar with AHK which is why I am using Pulover as it makes it easier for beginners like myself. Any help on how to accomplish this within PMC would be very much appreciated. Here is a snapshot of the AHK code PMC provides and where I need it to break if cell is blank or empty.

Loop
{
IfWinExist, - Excel Test
{
Sleep, 500
WinActivate, - Excel Test
Sleep, 333
}
Send, {Down}
Sleep, 200
Send, {LControl Down}{c}{LControl Up}
If Clipboard = ""
{
Break
}

hasantr wrote:

mjgfhy1 wrote:I'm a novice, got started by downloading Pulover and watching the tutorial videos. So far I have been able to accomplish everything I am looking for. Pulls #s from an excel file, works down a column, inputs the #s in another program. I'm having a hard time getting it to break the loop/stop once it reaches a blank or empty cell. I am not familiar with AHK which is why I am using Pulover as it makes it easier for beginners like myself. Any help on how to accomplish this within PMC would be very much appreciated. Here is a snapshot of the AHK code PMC provides and where I need it to break if cell is blank or empty.

We can help you more easily by sending us your PMC file and Excel file.

mjgfhy1 wrote:

hasantr wrote:

mjgfhy1 wrote:I'm a novice, got started by downloading Pulover and watching the tutorial videos. So far I have been able to accomplish everything I am looking for. Pulls #s from an excel file, works down a column, inputs the #s in another program. I'm having a hard time getting it to break the loop/stop once it reaches a blank or empty cell. I am not familiar with AHK which is why I am using Pulover as it makes it easier for beginners like myself. Any help on how to accomplish this within PMC would be very much appreciated. Here is a snapshot of the AHK code PMC provides and where I need it to break if cell is blank or empty.

We can help you more easily by sending us your PMC file and Excel file.

Attached excel file and AHK code. The forum wouldn't allow me to attach the PMC file as it said it wasn't supported.

hasantr wrote:

mjgfhy1 wrote:

hasantr wrote:

mjgfhy1 wrote:I'm a novice, got started by downloading Pulover and watching the tutorial videos. So far I have been able to accomplish everything I am looking for. Pulls #s from an excel file, works down a column, inputs the #s in another program. I'm having a hard time getting it to break the loop/stop once it reaches a blank or empty cell. I am not familiar with AHK which is why I am using Pulover as it makes it easier for beginners like myself. Any help on how to accomplish this within PMC would be very much appreciated. Here is a snapshot of the AHK code PMC provides and where I need it to break if cell is blank or empty.

You can add it in the zip file.

mjgfhy1 wrote:I was able to get my PMC file to do what I was looking. Works perfectly start to finish, stops at a blank cell. The issue I'm having now is when I converted to AHK file and a .EXE file, it doesn't work. Gets hungup on evaluating the contents of the active cell. Should break if the cell is empty but it is breaking/stopping even if the cell is filled with numbers. I tried a number of things such as <= "1" or <= 1 and doesn't work

Code: Select all

XL := ComObjActive("Excel.Application")
        If (XL.ActiveCell.Value := "")
        {
        }
        Else
        {
            Break

XL := ComObjActive("Excel.Application")
If (XL.ActiveCell.Value = "")
{
}
Else
{
	MsgBox,,,ContainValues
	;Break
}	

ibmguy wrote:Quick question...
I am writing a script that needs to be able to enter todays date as text in MM/DD/YY format
How would I do this in macro creator..
So for an example.. open up notepad and insert "today's date is MM/DD/YY"


Any help is much appreciated!

mjgfhy1 wrote:

hasantr wrote:

mjgfhy1 wrote:

hasantr wrote:

mjgfhy1 wrote:I'm a novice, got started by downloading Pulover and watching the tutorial videos. So far I have been able to accomplish everything I am looking for. Pulls #s from an excel file, works down a column, inputs the #s in another program. I'm having a hard time getting it to break the loop/stop once it reaches a blank or empty cell. I am not familiar with AHK which is why I am using Pulover as it makes it easier for beginners like myself. Any help on how to accomplish this within PMC would be very much appreciated. Here is a snapshot of the AHK code PMC provides and where I need it to break if cell is blank or empty.

You can add it in the zip file.

OK attached a zip file with everytyhing

GiefCat wrote:Hello! I just had a quick question as I'm having some issues with version 5.0.5 64-Bit.

When using the Mouse command for Move and Click, I click the ... for the coordinates, but when I right click nothing happens. I've just been entering the coordinates manually, but the same issue for the control click which is a lot of information to try and type in sometimes.

Also, if I try to do anything with the image search by clicking to hold and drag, it'll instantly just grab the entire window even while I'm still holding right click.

I've tried running as admin, uninstalling/reinstalling, running in windows compatibility mode, but still no luck. Running Windows 10, 64-Bit

Any advice on what could be happening?

brunocerq wrote:Hi,
This is a great piece of software, congrats.
I have 2 questions though:

First: When I create a timer to repeat a macro every x minutes, I would love to be able to choose a random interval of x minutes (minus or plus) for that action to run in a way that is not always at the same exact time.
Second: From what I tested, macros only run if I leave my desktop unlocked, since it it's locked the mouse will not click where I want it to because the windows are not there, is this correct?

Thanks

poophead42 wrote:Hello, just downloaded this yesterday and have been messing around with the program with some success.

Just wondering if it is possible to have 2 tasks perform at the same time.

I would like to have a recording of my screen moving around, and at the same time have the image finder looking for an image. When the image is found my screen would stop moving, and it would continue on with any further steps. Is it possible?

takayo97 wrote:could i use the image search on full screen PC games?
for example, search and click a button on a full screen pc game