Search found 269 matches

by Xeo786
17 Oct 2020, 02:15
Forum: Ask For Help
Topic: website drop down list select value Topic is solved
Replies: 14
Views: 212

Re: website drop down list select value Topic is solved

This way you can get aplha-month loop, 12 { formattime, m, 2020%A_Index%, MMMM Month .= m . "|" } Month := RTrim(Month, "|") ;;;; gui Gui, Add, DropDownList, x10 r10 vdobMonth gDobmonth,% Month loop parse to get numeral month Dobmonth: Gui, Submit, NoHide loop, parse, Month, `| if (A_LoopField = dob...
by Xeo786
16 Oct 2020, 08:21
Forum: Ask For Help
Topic: Changing Excel Cell Value Using COM Topic is solved
Replies: 2
Views: 68

Re: Changing Excel Cell Value Using COM Topic is solved

well you can change any cell value using com, you do not need to switch to any sheet or any cell everytime, in your case you are switching to activecell by using ".select" and using clipboard xl := ComObjActive("Excel.Application") cell := xl.Sheets(2).Range("B1") cell .value := RegExReplace(cell.te...
by Xeo786
16 Oct 2020, 08:12
Forum: Ask For Help
Topic: How to use fileopen to open a file with excel cell.value variable
Replies: 12
Views: 188

Re: How to use fileopen to open a file with excel cell.value variable

Using "cell.value" will set variable "2913.000000" and cell.text will set variable to actual visible text "2913" :think: file2open := "C:\test\test excel data.xlsx" XL := ComObjCreate( "Excel.Application" ) XL.Workbooks.Open(file2open) for Cell in XL.ActiveSheet.range("A2") MsgBox % "Cell value : " ...
by Xeo786
14 Oct 2020, 08:42
Forum: Ask For Help
Topic: Word\Excel Fastest way to read Topic is solved
Replies: 13
Views: 2279

Re: Word\Excel Fastest way to read Topic is solved

Comobjget is fastes way to read file without opening them example for excel xl := ComObjGet(filedestination) for sheet in xl.sheets safearray[a_index] := sheet.UsedRange msgbox, % "Rows: " safearray[1].rows.count() . "`n Coloumns: " safearray[1].columns.count() . "`n first cell" safearray[1].Cells(1...
by Xeo786
14 Oct 2020, 04:21
Forum: Ask For Help
Topic: How can i make the sound to the volume it was before?
Replies: 1
Views: 34

Re: How can i make the sound to the volume it was before?

example from https://www.autohotkey.com/docs/commands/SoundGet.htm SoundGet, master_volume MsgBox, Master volume is %master_volume% percent. SoundGet, master_mute, , mute MsgBox, Master Mute is currently %master_mute%. SoundGet, bass_level, Master, bass if ErrorLevel MsgBox, Error Description: %Erro...
by Xeo786
14 Oct 2020, 01:14
Forum: Ask For Help
Topic: Excel Conditional Formatting
Replies: 4
Views: 150

Re: Excel Conditional Formatting

FanaticGuru wrote:
13 Oct 2020, 12:45
; expression.Add (Type, Operator, Formula1, Formula2, TextOperator, ContainsOperator)
; expression represents a FormatConditions object

FG
Thanks
This gonna help me :D
by Xeo786
13 Oct 2020, 02:17
Forum: Ask For Help
Topic: Scan part of webpage for certain text, then click it
Replies: 8
Views: 212

Re: Scan part of webpage for certain text, then click it

You can use winhttp or XMLHTTP COM link := "https://www.google.com" winhttp := ComObjCreate("WinHttp.WinHttpRequest.5.1") winhttp.SetTimeouts(0, 0, 0, 0) winhttp.Open("GET", link,true) winhttp.Send() winhttp.WaitForResponse() MsgBox, % winhttp.responsetext link := "https://www.google.com" req := Com...
by Xeo786
10 Oct 2020, 03:30
Forum: Ask For Help
Topic: Excel Conditional Formatting
Replies: 4
Views: 150

Re: Excel Conditional Formatting

found solution on following link https://stackoverflow.com/questions/27579771/how-to-create-text-contains-formattingconditional-format-condition-for-excel but I was confuse how to define type.missing into AHK, I know "FormatConditions.Add(9,,,, "PASS", 0,,)" gona through error so I just set them emp...
by Xeo786
09 Oct 2020, 04:19
Forum: Ask For Help
Topic: Excel Workbook Copy To Topic is solved
Replies: 10
Views: 193

Re: Excel Workbook Copy To Topic is solved

following lil code will merge all workbooks that are open in single excel application whcih should be active, into one workbook and ask for saveas while merging it will close every workbook after getting all sheets merged one by one so all workbook remain as previous you get new workbook xl := ComOb...
by Xeo786
08 Oct 2020, 06:27
Forum: Scripts and Functions
Topic: ExcelToArray - Read excel data to AHK array
Replies: 7
Views: 1860

Re: Updated to v1.1

Thank you so much tmplinshi , now AHK class is more clear to me, Replaced ComObjGet with ComObjCreate . ComObjGet has issues on some Excel versions (or Windows version?), it will make the already opened Excel window blank. comobjget working for me, it was because of line 77 condition "if last_row &&...
by Xeo786
08 Oct 2020, 05:43
Forum: Scripts and Functions
Topic: ExcelToArray - Read excel data to AHK array
Replies: 7
Views: 1860

Re: ExcelToArray - Read excel data to AHK array

Would it not be better if we use ComObjGet instead of ComObjCreate? GetSafeArrFromXlFile(FileName, nSheet := 1, last_row := "", last_column := "") { fPath := this.GetFullPath(FileName) ;if this.IsFileInUse(fPath) { ; try wb := this.GetWorkbook(fpath) ;} if !wb { ; xlObj := ComObjCreate("Excel.Applic...
by Xeo786
08 Oct 2020, 02:51
Forum: Ask For Help
Topic: Shutdown command making it sleep instead?
Replies: 4
Views: 88

Re: Shutdown command making it sleep instead?

if read documentation carefully, there is example of force reboot ,

Code: Select all

;#1: Force a reboot (reboot + force = 2 + 4 = 6):
Shutdown, 6
so you would need (Force + shutdown) or (Force + Power down + shutdown)
try them both I suspect one them gonna work
by Xeo786
02 Oct 2020, 06:26
Forum: Ask For Help
Topic: Excel AutoFit columns for CSV files
Replies: 16
Views: 226

Re: Excel AutoFit columns for CSV files

Your code has Loop and it autofit only once and it will not effect 2nd csv you open, and you need to reload your script everytime you open new csv You better assign hotkey like ^F1 to autofit columns CSV which is already opened ^f1:: ComObjActive("excel.application").activesheet.Cells.Columns.AutoFi...
by Xeo786
02 Oct 2020, 04:00
Forum: Ask For Help
Topic: Excel AutoFit columns for CSV files
Replies: 16
Views: 226

Re: CTRL A not working in Excel

Well..! you can autofit all cells using "sheet.Cells" which apply to all cells I think entire active range ComObjActive("excel.application").activesheet.Cells.Columns.AutoFit ; activesheet.Cells.select will select all following code will autofit all coloumns (active range) of every sheet inside ever...
by Xeo786
01 Oct 2020, 04:42
Forum: Ask For Help
Topic: Saving the current opened file on two locations
Replies: 6
Views: 77

Re: Saving the current opened file on two locations

Thank you, mikeyww; but I don’t really understand. I was thinking of a script of this kind: #x:: ; a line to read and store the name of the current open file, like sort of (path = FolderName\Filename) ActiveDocument.SaveAs C:\path ActiveDocument.SaveAs D:\path Return I need to know the syntax for t...
by Xeo786
30 Sep 2020, 09:19
Forum: Ask For Help
Topic: Is it possible to display all row and column numbers on cells in Excel?
Replies: 2
Views: 3789

Re: Is it possible to display all row and column numbers on cells in Excel?

well you can achieve all most anything with excel using AHK and what you want you can do in many ways i have wrote this code just for fun press Ctrl+F it will show cell address in tooltip while Ctrl+F pressed use arrow keys to change cell address ^f:: XlApp := ComObjActive("Excel.Application") x := ...
by Xeo786
30 Sep 2020, 06:22
Forum: Ask For Help
Topic: MouseClick when monitor is connect off
Replies: 9
Views: 123

Re: MouseClick when monitor is connect off

You can change your Power management plan from control panel
Idk what your setting are, check it Control Panel\All Control Panel Items\Power Options\Edit Plan Settings

set Display off: after 30 minutes and Put Computer sleep : Never
by Xeo786
30 Sep 2020, 05:44
Forum: Ask For Help
Topic: Why did Range.End go wrong in AHK Topic is solved
Replies: 5
Views: 3771

Re: Why did Range.End go wrong in AHK Topic is solved

i didn't realized selection is empty too you need to define its source i.e excel.Selection

Code: Select all

excel.ActiveSheet.Range(excel.Selection, excel.Selection.End(-4161)).Select

Go to advanced search