AutoHotkey Community

flyingDman

For Excel the `n is enough. No need to add the `r.

Nice script Kon.(handled my 6000 + bookmarks w/ no problem...). You suggested other ways. Only STRX comes to mind (http://www.autohotkey.com/board/topic/4 ... -xml-html/).

flyingDman

What ahk version are you running?

flyingDman

Please Let me know if there is better logic than this.

So it seems you do not care about something better... Why do you even post the question?

flyingDman

First of all I am sure that this is a topic tackled here before. I didn't look (you might not have either...) It's not only a string split that is needed. You also need to put the dates in a format you can do math on (yyyymmdd, i.e padding with 0 when needed) and then write the algorithm to select t...

flyingDman

This would be a different way and much faster, particularly if the Excel range is large (say several thousand rows or more). List := "list.txt", FilePath := "source.xlsx" fileread, list, %list% StringReplace, list,list,`r`n,`,, All Xl := ComObjCreate("Excel.Application") ;create a handle Xl.Workbook...

flyingDman

try something like this: List := "list.txt" FilePath := "source.xlsx" Xl := ComObjCreate("Excel.Application") ;create a handle Xl.Workbooks.Open(a_scriptdir "\" FilePath,0,0) ;open xl file invisible Loop, Read, %List% ;retrieves every line { if !c := xl.Range("A:A").Find(A_LoopReadLine) ;if not foun...

flyingDman

My original script does send from box2 to box1 and vv. Wonder why I does not work on your system. Try this (which will also append rather than replace). Gui, Add, Edit, h100 w100 vBox1 Gui, Add, Button, w100 gBox1, send to box 2 Gui, Show, x100, box1 Gui, Box2: Add, Edit, h100 w100 vBox2 Gui, Box2: ...

flyingDman

Would this help?: Gui, Add, Edit, h100 w100 vBox1 Gui, Add, Button, w100 gBox1, send to box 2 Gui, Show, x100, box1 Gui, Box2: Add, Edit, h100 w100 vBox2 Gui, Box2: Add, Button, w100 gBox2, Send to box 1 Gui, Box2: Show, x300, box2 return box1: GuiControlGet, oVar1, , box1 GuiControl, box2:, box2, %...

flyingDman

Or: OnMessage(0x21,"WatchClick") html := "<html><head><Style>body, p {margin-left: 50;margin-top: 16;font-family: 'Arial'; font-size: 50pt; overflow-y:auto}</style>" html .= "</head><body><p>1</p></html></head>" Gui, color, 20A2DA, white gui, margin,20,20 gui, add, ActiveX, vWB w200 h100, Shell.Expl...

flyingDman

Not the solution you want (just because it is too complicated), but based on http://www.autohotkey.com/board/topic/32364-edit-control-background-color/ you can do this (all credit to SKAN): TextBackgroundColor := 0xFFFFFF ; A custom color in BGR format. TextBackgroundBrush := DllCall("CreateSolidBru...

flyingDman

Very clever! Works nicely (until you uncomment the tooltip line...). Do not know how much you leaned on SKAN's work, but it also shows the brilliant work he has contributed (and this back in 2007...).

flyingDman

Wouldn't you need a negative period to run the timers once and keep the loops?

flyingDman

Thank you very much for the clarification. This is fascinating.

flyingDman

@trismark: thank you. that one was missing in my collection. This works as well: xl.selection.PasteSpecial(-4163,-4142,,ComObj(0xB,-1)) But tell me why would this work: Xl.Workbooks.Open("testfile.xls",0,1) but not this: xl.selection.PasteSpecial(-4163,-4142,0,1) in both cases the last 1 refers to "...

flyingDman

Change the last line if your function to:

Code: Select all

return % index * 1

or, better, dump the function and use:

Code: Select all

col := xl.range("f:f").column

flyingDman

I do not think you can set the tab size for a text control. You can for a edit control and you can have an edit control behave and look like a text control. Try this:

Code: Select all

Gui, Add, edit, vMyEdit r16 t8 t16 t32 t64 t128 readonly -E0x200 	-VScroll, 1	2	3	4	5	6	7	8	9

flyingDman

Will be using it....

flyingDman

Who said it was temporary?

flyingDman

Appskey does not work. You need to scan the code for that key (see at the bottom of the "List of Keys, Mouse Buttons, and Joystick Controls" page in the help file) but the code is likely SC15D. The hotkeys SC15D:: , RControl & SC15D:: and ^SC15D:: for instance run fine on my system.

flyingDman

Good work Tank! Eventually all will want to know how we can avoid what has happened i.e. that a single person can destroy or threaten to destroy the forum and years of expertise. This is not only important in case of negligence or wrongdoing, but also when that person his hit by the proverbial bus.....

Search found 2840 matches

Re: I need to convert HTML bookmark export to CSV

Re: Get maximum date!

Re: Get maximum date!

Re: Get maximum date!

Re: Search in Excel file

Re: Search in Excel file

Re: Send variables from GUI2 to GUI1

Re: Send variables from GUI2 to GUI1

Re: Gui Text Control with white background?

Re: Gui Text Control with white background?

Re: Multiple While Loops?

Re: Multiple While Loops?

Re: Com Excel PasteSpecial w/ Transpose Command Error Topic is solved

Re: Com Excel PasteSpecial w/ Transpose Command Error Topic is solved

Re: Excel sorting-issue with variable?

Re: Control size of A_Tab in Gui?

Re: Highlite - Syntax Highlighting For Posting AHK Scripts

Re: what happened to the original website ?

Re: Combining the Right Control key and the AppsKey

Re: The First Step