AutoHotkey Community

Xeo786

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...

Xeo786

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...

Xeo786

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 : " ...

Xeo786

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...

Xeo786

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...

Xeo786

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

Xeo786

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...

Xeo786

great ............!

Xeo786

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...

Xeo786

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...

Xeo786

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 &&...

Xeo786

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...

Xeo786

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

Xeo786

You might find RunCMD() "the rewrite of old StdoutToVar()" useful to use comspec

https://www.autohotkey.com/boards/viewtopic.php?f=6&t=74647&hilit=StdoutToVar

Xeo786

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...

Xeo786

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...

Xeo786

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...

Xeo786

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 := ...

Xeo786

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

Xeo786

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

Search found 269 matches

Re: website drop down list select value Topic is solved

Re: Changing Excel Cell Value Using COM Topic is solved

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

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

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

Re: Excel Conditional Formatting

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

Re: Imagen() : A fade-in/fade-out animator for picture control

Re: Excel Conditional Formatting

Re: Excel Workbook Copy To Topic is solved

Re: Updated to v1.1

Re: ExcelToArray - Read excel data to AHK array

Re: Shutdown command making it sleep instead?

Re: Use / define - Run Command /c - ErrorLevel / case Topic is solved

Re: Excel AutoFit columns for CSV files

Re: CTRL A not working in Excel

Re: Saving the current opened file on two locations

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

Re: MouseClick when monitor is connect off

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