Search found 111 matches
- 20 Mar 2018, 03:40
- Forum: Ask for Help (v1)
- Topic: Excel Range error Topic is solved
- Replies: 5
- Views: 1689
Re: Excel Range error Topic is solved
yes i must use union if i want to delete the right columns after the first one column... B become A etc. Thank you
- 19 Mar 2018, 13:17
- Forum: Ask for Help (v1)
- Topic: Excel Range error Topic is solved
- Replies: 5
- Views: 1689
Re: Excel Range error Topic is solved
Range limit is 255 characters... i need to use
Code: Select all
xl.Application.Union(xl.Range(rangeA), xl.Range(rangeB).Interior.ColorIndex := 46
- 19 Mar 2018, 12:46
- Forum: Ask for Help (v1)
- Topic: Excel Range error Topic is solved
- Replies: 5
- Views: 1689
Re: Excel Range error Topic is solved
Ahk and COM
im trying to delete entire columns with this function I have used many times without problems
im trying to delete entire columns with this function I have used many times without problems
Code: Select all
XlColDelete(xl, ColObj){
for i, col in ColObj
Range .= col ":" col . ((i = ColObj.MaxIndex()) ? "" : ";")
xl.Application.ActiveSheet.Range(Range).Delete
}
- 19 Mar 2018, 10:58
- Forum: Ask for Help (v1)
- Topic: Excel Range error Topic is solved
- Replies: 5
- Views: 1689
Excel Range error Topic is solved
Where is the problem in this excel range? D:D;AE:AE;AB:AB;O:O;P:P;T:T;X:X;BJ:BJ;BI:BI;AV:AV;AS:AS;AT:AT;AR:AR;Q:Q;S:S;BD:BD;BF:BF;BB:BB;AZ:AZ;AX:AX;BL:BL;BK:BK;BE:BE;BG:BG;BC:BC;BA:BA;AY:AY;AM:AM;AN:AN;AQ:AQ;AD:AD;Y:Y;AC:AC;AA:AA;AU:AU;H:H;U:U;W:W;V:V;AH:AH;AW:AW;AO:AO;AG:AG;AI:AI;AJ:AJ;AP:AP;R:R;A:...
- 12 Mar 2018, 08:51
- Forum: Tips and Tricks (v1)
- Topic: [GUI] Use HTML and CSS for your GUIs!
- Replies: 148
- Views: 159461
Re: [GUI] Use HTML and CSS for your GUIs!
do you mean the screenshot in the post?
- 11 Mar 2018, 13:18
- Forum: Scripts and Functions (v1)
- Topic: FirstImageOnGoogle() - Google Image Search
- Replies: 1
- Views: 1420
FirstImageOnGoogle() - Google Image Search
born to find the first one, name remains, now you can choose from 1 to 100 (first shown without scrolling the page). ; Test wb := ComObjCreate("InternetExplorer.Application") wb.Visible := true Start := A_TickCount for i, Name in Animals := ["dog", "cat", "bear", "penguin"] { Index := (Name = "cat")...
- 11 Mar 2018, 02:31
- Forum: Tips and Tricks (v1)
- Topic: [GUI] Use HTML and CSS for your GUIs!
- Replies: 148
- Views: 159461
Re: [GUI] Use HTML and CSS for your GUIs!
Thank you joedf! I'm trying to log very long script steps... https://www.dropbox.com/s/kgyva6i5k3g4v6d/11_03_18_08_09_14.png?dl=1 class HtmlLogClass { __New(GuiName := "HtmlLog", W := "", H := "", MyCss := ""){ static if FileExist(MyCss) FileRead, MyCss, % MyCss MyCss := RegExReplace(MyCss, "i)\<(\/...
- 05 Mar 2018, 06:01
- Forum: Ask for Help (v1)
- Topic: Read SQL database
- Replies: 1
- Views: 776
- 05 Mar 2018, 05:27
- Forum: Ask for Help (v1)
- Topic: GuiSize inside class
- Replies: 0
- Views: 522
GuiSize inside class
t := New Test() Return class Test { __New(GuiName := "Name"){ static CssBase= ( body { font-family: Segoe UI,Frutiger,Frutiger Linotype,Dejavu Sans,Helvetica Neue,Arial,sans-serif; background-color: White; color: Black; font-size:15px; line-height: 1.4; } img { vertical-align: text-baseline;} a img...
- 24 Feb 2017, 12:33
- Forum: Ask for Help (v1)
- Topic: [Need help] Send increase day
- Replies: 3
- Views: 1303
- 24 Feb 2017, 11:49
- Forum: Ask for Help (v1)
- Topic: [Need help] Send increase day
- Replies: 3
- Views: 1303
Re: [Need help] Send increase day
Code: Select all
tomorrow := A_Now
tomorrow += 1, Days
FormatTime, tomorrow, % tomorrow, dd/MM
MsgBox, % tomorrow
- 24 Feb 2017, 05:08
- Forum: Ask for Help (v1)
- Topic: Outlook(COM): How to put an image in an e-mail?
- Replies: 2
- Views: 1358
- 18 Feb 2017, 13:59
- Forum: Ask for Help (v1)
- Topic: Find all days on even and odd weeks
- Replies: 23
- Views: 5744
Re: Find all days on even and odd weeks
sorry, my function based entirely on FormatTime "dddd" empty return... makes sense?
- 18 Feb 2017, 04:18
- Forum: Ask for Help (v1)
- Topic: Find all days on even and odd weeks
- Replies: 23
- Views: 5744
Re: Find all days on even and odd weeks
I tried again ;obj := AllDaysOnOddOrEvenWeeks("2017", "lunedì", False, True) ; Italian obj := AllDaysOnOddOrEvenWeeks("2017", "monday", False, True) ; i think its for i, Day in Obj { FormatTime, Day, % Day, MMMM d example .= Day "`n" } MsgBox, % example AllDaysOnOddOrEvenWeeks(Year, IWantDaysName, O...
- 17 Feb 2017, 11:06
- Forum: Ask for Help (v1)
- Topic: Find all days on even and odd weeks
- Replies: 23
- Views: 5744
Re: Find all days on even and odd weeks
:idea: y := 2017 obj := Object() obj.Year := y loop 12 { m := (A_Index < 10) ? 0 . A_Index : A_Index Loop { d := (A_Index < 10) ? 0 . A_Index : A_Index FormatTime, DayName, % y . m . d, dddd if !DayName Break FormatTime, MonthName, % y . m . d, MMMM if !IsObject(obj[MonthName]) obj[MonthName] := Obj...
- 17 Feb 2017, 08:46
- Forum: Ask for Help (v1)
- Topic: Selecting particular existing IE and clicking things. Topic is solved
- Replies: 8
- Views: 2406
Re: Selecting particular existing IE and clicking things. Topic is solved
wb := IEGet() / wb := IEGet("badwindow")
- 17 Feb 2017, 06:52
- Forum: Ask for Help (v1)
- Topic: iWB Learner Source
- Replies: 4
- Views: 1962
- 16 Feb 2017, 03:03
- Forum: Ask for Help (v1)
- Topic: Outlook signature with text and image
- Replies: 9
- Views: 5354
Re: Outlook signature with text and image
Winclip wins!
- 15 Feb 2017, 13:47
- Forum: Ask for Help (v1)
- Topic: Get coords from output list Topic is solved
- Replies: 4
- Views: 1613
Re: Get coords from output list Topic is solved
Code: Select all
Loop % coords.MaxIndex()
MsgBox, % "[" A_Index "] " coords[A_Index].x ", " coords[A_Index].y
MsgBox, % coords.1.x ", " coords.1.y
- 15 Feb 2017, 08:46
- Forum: Ask for Help (v1)
- Topic: Outlook signature with text and image
- Replies: 9
- Views: 5354
Re: Outlook signature with text and image
or Picture := a_desktop "\picture.jpg" Try m := ComObjActive("Outlook.Application").CreateItem(0) Catch m := ComObjCreate("Outlook.Application").CreateItem(0) m.Subject := "Subject" ;m.To := A ;m.CC := CC html= ( <html> <body> <font size="2" face="Calibri" color="black"> <p>Best Regards,<br>Have a n...