Search found 176 matches

by Klarion
16 May 2019, 21:21
Forum: Ask for Help (v1)
Topic: Can AHk guess a file directory using the first characters? Topic is solved
Replies: 12
Views: 2861

Re: Can AHk guess a file directory using the first characters? Topic is solved

@awel20
I am Not talking to you
I am Not interested in you and your codes at all
Mind your own codes
by Klarion
16 May 2019, 12:53
Forum: Ask for Help (v1)
Topic: Can AHk guess a file directory using the first characters? Topic is solved
Replies: 12
Views: 2861

Re: Can AHk guess a file directory using the first characters? Topic is solved

simple testing.. #SingleInstance, Force #WinActivateForce SetBatchLines, -1 myVar = ( TX07 - 52411 CA07 - 52412 WA07 - 52413 ) Gui, 메인창: New,, % " testing... " Gui, 메인창: Add, Text, y+15 , % myVar Gui, 메인창: Add, Text, y+15 , your Input : Gui, 메인창: Add, Edit, x+7 yp-3 w400 v입력, CA Gui, 메인창: Add, Butto...
by Klarion
16 May 2019, 04:54
Forum: Ask for Help (v1)
Topic: Coloring the Excel Cell Topic is solved
Replies: 28
Views: 6430

Re: Coloring the Excel Cell Topic is solved

that is not my Desktop value
because, my Desktop value is 0xC37E2B
by Klarion
16 May 2019, 04:52
Forum: Ask for Help (v1)
Topic: Coloring the Excel Cell Topic is solved
Replies: 28
Views: 6430

Re: Coloring the Excel Cell Topic is solved

Code: Select all

PixelGetColor, _, 0, 0
MsgBox % _
캡처.PNG
캡처.PNG (8.94 KiB) Viewed 1626 times
by Klarion
16 May 2019, 04:20
Forum: Ask for Help (v1)
Topic: Coloring the Excel Cell Topic is solved
Replies: 28
Views: 6430

Re: Coloring the Excel Cell Topic is solved

That is all, no more codes to post and you do not need no more codes
-You know all the detail procedures and goals

The strange color code is emitted from very top of the Excel screen (I mean top of the top - Desktop itself or boundary line I guess)

Regards
by Klarion
16 May 2019, 01:27
Forum: Ask for Help (v1)
Topic: Coloring the Excel Cell Topic is solved
Replies: 28
Views: 6430

Re: Coloring the Excel Cell Topic is solved

you do not need Format function
PixelGetColor function emits perfect hex format
and

that is not the point here
the point is unexpected return value of it
that is not documented at Help file though, I guess, it is some different representation of Color - I do not care.
by Klarion
15 May 2019, 10:46
Forum: Ask for Help (v1)
Topic: Coloring the Excel Cell Topic is solved
Replies: 28
Views: 6430

Re: Coloring the Excel Cell Topic is solved

Just tested

What the heck is color value 0xFFFFFFFF ??

Code: Select all

_ := ComObjActive("Excel.Application")
Loop, 35 {
	c ++
	r := 0
	Loop, 30 {
		r ++
		PixelGetColor, cVal, % c, % r
		If(cVal != 0xFFFFFFFF)
			_.ActiveWorkbook.ActiveSheet.Cells(r, c).Interior.Color := cVal
	}}
캡처.PNG
캡처.PNG (17.82 KiB) Viewed 4404 times
by Klarion
15 May 2019, 03:39
Forum: Ask for Help (v1)
Topic: Coloring the Excel Cell Topic is solved
Replies: 28
Views: 6430

Re: Coloring the Excel Cell Topic is solved

you are having a good time
by Klarion
14 May 2019, 22:58
Forum: Ask for Help (v1)
Topic: Coloring the Excel Cell Topic is solved
Replies: 28
Views: 6430

Re: Coloring the Excel Cell Topic is solved

this kind of people who do not know how to use the basic keyword Thanks
I do not like them
by Klarion
14 May 2019, 04:00
Forum: Ask for Help (v1)
Topic: Coloring the Excel Cell Topic is solved
Replies: 28
Views: 6430

Re: Coloring the Excel Cell Topic is solved

That does work properly
It emits error because YOU coded errors
by Klarion
14 May 2019, 03:21
Forum: Ask for Help (v1)
Topic: Coloring the Excel Cell Topic is solved
Replies: 28
Views: 6430

Re: Coloring the Excel Cell Topic is solved

use BGR not RGB
and
use expressions properly

Good Luck
by Klarion
13 May 2019, 20:53
Forum: Ask for Help (v1)
Topic: Function to multiply all digits in a number (Multiplication Persistence Test) Topic is solved
Replies: 6
Views: 1928

Re: Function to multiply all digits in a number (Multiplication Persistence Test) Topic is solved

very effective way to waste somebody else's precious time
by Oxford dictionary digit means Any of the numerals from 0 to 9.
by Klarion
12 May 2019, 05:25
Forum: Ask for Help (v1)
Topic: Some Basic Regex group Capture / Non-Capture Questions Topic is solved
Replies: 10
Views: 3804

Re: Some Basic Regex group Capture / Non-Capture Questions Topic is solved

Good
I like the Green Check Mark

and
some of RegEx contents are not really needed for the beginner level
each level has its own ways of solving problem

ah, I am at the beginner level. Do not misunderstand me.

Good Luck To You
by Klarion
11 May 2019, 22:57
Forum: Ask for Help (v1)
Topic: Some Basic Regex group Capture / Non-Capture Questions Topic is solved
Replies: 10
Views: 3804

Re: Some Basic Regex group Capture / Non-Capture Questions Topic is solved

I do not care whatever you have in your mind about Capture / Non-Capture , just enjoy.. _ := "Hello World" RegExMatch(_, "(?<=Hello )World", x) MsgBox % "" . x "`n" . RegExReplace(_, "Hello (?=World)") and make all your previous help post with Green Check if you found a good answer (of course includ...
by Klarion
10 May 2019, 16:39
Forum: Ask for Help (v1)
Topic: COM - Excel - Cell content = floating point? Topic is solved
Replies: 12
Views: 2632

Re: COM - Excel - Cell content = floating point? Topic is solved

Code: Select all

a := [123.123456
, 123.123450
, 123.123400
, 123.123000
, 123.120000
, 123.100000 
, 123.000000
, 123000000]
For Each, x In a
	r .= RegExReplace(RegExReplace(x, "(\.\d*?)0+$", "$1"), "\.$") "`n"
MsgBox % r
by Klarion
10 May 2019, 11:34
Forum: Ask for Help (v1)
Topic: COM - Excel - Cell content = floating point? Topic is solved
Replies: 12
Views: 2632

Re: COM - Excel - Cell content = floating point? Topic is solved

@drawback
I can not confirm one of your comment
I have changed the cell's format into Text so I got 2000 not 2000.000000 from COM_Excel_of_AHK
This is written in SharedString file so it is NOT a floating point nor integers nor decimal numbers.
It is just a string nothing else

Go to advanced search