Search found 37 matches

by Yoshimu
17 May 2017, 11:13
Forum: Ask For Help
Topic: Excel (VBA) in AHK Topic is solved
Replies: 3
Views: 872

Re: Excel (VBA) in AHK Topic is solved

Great FG.
I was trying Find function before i started this topic, but thanks to ur example I udderstood how it works ( and why it didnt work before)

I simply needed this:

Code: Select all

XL.Columns("G").Find("John").Select
by Yoshimu
17 May 2017, 03:09
Forum: Ask For Help
Topic: Excel (VBA) in AHK Topic is solved
Replies: 3
Views: 872

Excel (VBA) in AHK Topic is solved

Hey, at this moment I use: XL.Range("G200").Select XL.ActiveCell.Offset(0,0).Value := Var1 But this cell "A200" every day changes. So I Would like to use FInd function, that will look for defined text eg "Client name" in Column G (or other). Than if VBA found, select this cell. Is it possible to imp...
by Yoshimu
08 Aug 2016, 07:53
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool

Hummmm... Not AHK, but Uberi's ExprEval used in the Eval function. I don't think I'll be able to fix that one so quickly, though... Sure, take ur time. For now i use (which work, but i like to minimalize my Macro in PCM ) 1|[Expression]|DataDzien := A_DD + A_Index|1|5|Expression||||0xFFFF00| 2|Comp...
by Yoshimu
07 Aug 2016, 13:56
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool

I tried that already :) but still no "0" before
I also tried

Code: Select all

DataDzien2 := "0" DataDzien
DataDzien := (DataDzien < 10) ? DataDzien2 : DataDzien
But also the same

When i did

Code: Select all

DataDzien := (DataDzien < 10) ? 0000123 : DataDzien
The result is (for DataDzien <10):
123
So AHK removes all 0

Any idea?
by Yoshimu
07 Aug 2016, 12:31
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Version Update: 5.0.5

Your code should work now after correcting the variable name. Ok, i see how Ternary operator works, but my code wont work as i want :) I want to: 1. Increment Day by A_index 2. place 0 before single number values. To make this: 05 06 07 08 09 10 11 This code is Assign 0 to my var if it is <10, and ...
by Yoshimu
07 Aug 2016, 10:31
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Pulover's Macro Creator v5.0.4 - The Complete Automation Tool

Hmmm, it's not working
Can you look?

Code: Select all

[PMC Code v5.0.3]|^F4||1|Screen,2,Fast,0,1,Input,-1,-1,1|1|Macro5
Groups=Start:1
1|[Expression]|DateDzien := A_DD + A_Index`nDataDzien := (DataDzien < 10) ? 0 : DataDzien|1|5|Expression|||||
2|[Text]|%DataDzien%|1|5|Send|||||
by Yoshimu
07 Aug 2016, 08:14
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Pulover's Macro Creator v5.0.4 - The Complete Automation Tool

Hey,
How to add If excpression in Expression/Com Object Box?
I wanna add if statement to add "0" before single number - because it is date

DateDay := A_DD + A_Index
DateDay := "0" DateDay

so it would be like this
If(DateDay<10) than DateDay := "0" DateDay
by Yoshimu
27 Jun 2016, 08:11
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Pulover's Macro Creator v5.0.3 - The Complete Automation Tool

hey,
I have lots of crashes when i use "functions". I have lots of them in my script, and whole PMC crashes during Play.
but i'm guessing that might be AHK problem.
by Yoshimu
25 Apr 2016, 11:33
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Pulover's Macro Creator v5.0.1 - The Complete Automation Tool

ok, i will also send you few things i noticed in this new version.
And also i started correcting Polish translation in Lang File, so i will send you when I finished or E.g half-finished :)

PS: this version, crashes alot, is there any error Log?
by Yoshimu
25 Apr 2016, 11:12
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Pulover's Macro Creator v5.0.1 - The Complete Automation Tool

So is it possible to use function inside [Text] ? To use a function directly inside a command, you need to make the whole parameter an expression, like this: 1|[Text]|% "Random city is " RandCity() "... Next text..."|1|0|SendRaw||||| Ok, How about multiple Functions/variables in one raw? Is it poss...
by Yoshimu
24 Apr 2016, 14:12
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Pulover's Macro Creator v5.0.1 - The Complete Automation Tool

pulover, i have question for you. I'm tryding to do "random variable" like in example, but in result i need variable which i can use inside "text", like this: 1|[Text]|Random city is %RandCity%.... text.....|1|2222|Send||||| becuase now i can only do this: 1|[Text]|Random city is : |1|2222|SendRaw||...
by Yoshimu
23 Apr 2016, 15:15
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Pulover's Macro Creator v5.0.0 - The Complete Automation Tool

Pulover, Great piece of work here .. I just discovered this! I am having problems with loading a macro file. I am able to record the macro file. When I close the program and attempt to open the .pmc file I saved, the program pegs the CPU at 100% of one core for several minutes without any visual pr...
by Yoshimu
18 Apr 2016, 07:04
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Pulover's Macro Creator v5.0.0 - The Complete Automation Tool

Pulover, New version looks great, and new function are fantastic, thanks. But i found problem in ImageSearch (or maybe it is the way you wanted it to be :D ) In version 4... when i used press Mouse Button in ImageSearch, it pressed exactly in the left top corner. but now in this v5, it doesnt. It mo...
by Yoshimu
28 Mar 2016, 12:28
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Macro Creator v4.1.3 - Automation Tool (Recorder & Writer)

And other thing, when PMC crashes, it sometimes delete the saved file, which is open. Probably when it crashes during the saving routine... I do experience crashes every now and then at random situations but I can't find a cause. The odd part is that I ran PMC in a Debug built of AHK for a week and...
by Yoshimu
28 Mar 2016, 10:29
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Macro Creator v4.1.3 - Automation Tool (Recorder & Writer)

Great, i wanna ask for tutorial how use excel commands in PMC and how it works (i dont know if it's already, but i saw it on some screenshots) I think I also know few bugs: Since....hmmm....ever i guess.....PMC dont always save correct script. (My script has almost 1Mb, and sometimes it saves empty ...
by Yoshimu
09 Mar 2016, 16:55
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Macro Creator v4.1.3 - Automation Tool (Recorder & Writer)

u have playback option (e.g only selected rows )
by Yoshimu
19 Dec 2015, 05:34
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Macro Creator v4.1.3 - Automation Tool (Recorder & Writer)

Adorabla, I just used If Statement connected to Image search -> if Image is NOT found. There is option "else" too. You can download my simple script, and go inside that if statement, and look what you can change. SturmGhost, i know u can slow or increase speed by 2x, 4x, 8x and 16x, but i dont know ...
by Yoshimu
18 Dec 2015, 06:33
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Macro Creator v4.1.3 - Automation Tool (Recorder & Writer)

How can i implement a way in this loop that tells the Script to react with an action if the image is found or if the image wasnt found at the same time ? -> Now the image was found -> Click, %FoundX%, %FoundY% Left, 1 -> The Image was not found -> Click on another Position or something like that I ...
by Yoshimu
13 Dec 2015, 03:45
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Macro Creator v4.1.3 - Automation Tool (Recorder & Writer)

Ok thx. I added library file into PMC. But now is it possible to use this function inside "Send" with "Array". Something like: Array1 := Array("Var1","Var2",Var3".'Var4","Var5") loop, 5 { Send, % Array1[rand(1, array1.maxindex() )] } Or maybe there is a different way to do the same thing. I load arr...
by Yoshimu
12 Dec 2015, 05:21
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632314

Re: Macro Creator v4.1.3 - Automation Tool (Recorder & Writer)

Does anyone know if it is possible to make my own function in PMC?
I need to do this in PCM:

Code: Select all

rand( x, y )
{
   Random, var, %x%, %y%
   return var
}

Go to advanced search