Search found 486 matches

by jmeneses
02 Oct 2019, 08:58
Forum: Ask For Help
Topic: How to use multiple input as an output in a formula Topic is solved
Replies: 4
Views: 193

Re: How to use multiple input as an output in a formula Topic is solved

:shock: Send !v Sleep 100 Send r Sleep 100 Send !n Sleep 100 Send !o Sleep 100 Send % "Mass Update of Requisitions{TAB}" Sleep 100 ; Send !c Sleep 100 Send % "Operating unit field{TAB}PREP{TAB}Old preaprer field{TAB}New preparer field{TAB 2}Requisition number field{TAB}Requisition number field" Slee...
by jmeneses
02 Oct 2019, 08:45
Forum: Ask For Help
Topic: Switch Case - Expression & Expression:
Replies: 4
Views: 243

Re: Switch Case - Expression & Expression:

Another way bool:=true switchValue:="yo" switch (switchValue bool) { case ("yo" true): Msgbox 0x40000,, % "CASE 1 (" switchValue ")-(" bool ")" case ("yo" false) : Msgbox 0x40000,, % "CASE 2 (" switchValue ")-(" bool ")" Default: Msgbox 0x40000,, % "NONE (" switchValue ")-(" bool ")" } ExitApp
by jmeneses
02 Oct 2019, 08:11
Forum: Ask For Help
Topic: Read Excel file with worksheets
Replies: 8
Views: 391

Re: Read Excel file with worksheets

Hello Paddy9888 and welcome, a small sample Press f3 with your book excel opened DetectHiddenWindows on WinActivate ahk_class XLMAIN Return #If WinActive("ahk_exe EXCEL.exe") F3:: WinWaitActive, ahk_class XLMAIN oExcel := ComObjActive("Excel.Application") ;Loop Sheet's For oSheet in oExcel.Sheets { ...
by jmeneses
19 Sep 2019, 07:24
Forum: Ask For Help
Topic: Convert cell names in spreadsheets to numbers Topic is solved
Replies: 16
Views: 639

Re: Convert cell names in spreadsheets to numbers Topic is solved

Range "AA128" is Row 128 column 27 as you can see by this: xl := ComObjActive("Excel.Application") MsgBox % xl.Range("AA128").Address(,,xlR1C1:=-4150) If you change the references style to R1C1 in the EXCEL options you will see numbers instead of letters in the column header. https://excelchamps.co...
by jmeneses
19 Sep 2019, 04:34
Forum: Ask For Help
Topic: Convert cell names in spreadsheets to numbers Topic is solved
Replies: 16
Views: 639

Re: Convert cell names in spreadsheets to numbers Topic is solved

Code: Select all

pX := 26
pY := 127
Msgbox 0x40000,, % ExcelColumnNumberToName(px+1) pY +1
ExitApp

; https://www.autohotkey.com/boards/viewtopic.php?f=5&t=34244&p=164723#p164723
ExcelColumnNumberToName(x) {
 Return (x<1 ? "" : ExcelColumnNumberToName(Floor((x - 1) / 26)) Chr(Mod(x - 1, 26) + Asc("A")) )
}
by jmeneses
16 Sep 2019, 09:35
Forum: Ask For Help
Topic: Copy and Paste Formatting on Excel
Replies: 3
Views: 259

Re: Copy and Paste Formatting on Excel

Hello Snipper and welcome, try this to see if it's what you are looking for #singleinstance force WinActivate ahk_class XLMAIN ;https://docs.microsoft.com/en-us/office/vba/api/excel.range.pastespecial xlPasteAll := -4104 ; Everything will be pasted. xlPasteAllExceptBorders := 7 ; Everything except b...
by jmeneses
10 Sep 2019, 08:37
Forum: Ask For Help
Topic: How to access custom class multidimensional array Topic is solved
Replies: 2
Views: 162

Re: How to access custom class multidimensional array Topic is solved

;Msgbox, % ExploreObj(myList) msgBox, % myList._List.1.text . "`n" . myList._list[2].text for k, v in myList._List { Msgbox, % v.text ; here is problem! }
by jmeneses
28 Apr 2019, 10:03
Forum: Announcements
Topic: Test build - InputHook, long paths, switch-case
Replies: 24
Views: 3326

Re: Test build - InputHook, long paths, switch-case

Many thanks @lexikos for your exceptional job
@just me it is very easy to criticize a written page because you do not write it your ready your alias says it all
Written from my mobile
by jmeneses
21 Feb 2019, 06:45
Forum: Ask For Help
Topic: How to copy Excel rows and process data
Replies: 4
Views: 462

Re: How to copy Excel rows and process data

Hi Omar,
You can search the forum but this https://github.com/tmplinshi/ExcelToArray it meets
by jmeneses
16 Jan 2019, 05:33
Forum: Ask For Help
Topic: Looking for help writing script Topic is solved
Replies: 3
Views: 433

Re: Looking for help writing script Topic is solved

hI Sandm4n2355 and welcome Other way but whit loop #NoEnv #SingleInstance force #Persistent #MaxThreadsPerHotkey, 2 ;may be necessary for allowing you to turn off the while loop Return F8:: toggle:=!toggle While toggle { Click Sleep 100 Send {Space 3} Sleep 100 Send 3 Sleep 100 Send {Space 3} Sleep ...
by jmeneses
11 Jan 2019, 02:02
Forum: Ask For Help
Topic: Having issues using an array.
Replies: 7
Views: 668

Re: Having issues using an array.

Hey swagfag!!
Happy birthday in ahk forum!! :bravo: :happybday: :bravo:
by jmeneses
10 Jan 2019, 07:38
Forum: Ask For Help
Topic: Having issues using an array.
Replies: 7
Views: 668

Re: Having issues using an array.

Try this

Code: Select all

MouseMove, % XYpos[1], % XYpos[2], 50 
by jmeneses
10 Jan 2019, 02:02
Forum: Scripts and Functions
Topic: Excel Enum Constants Search
Replies: 13
Views: 1722

Re: Excel Enum Constants Search

Hey burque505 another time
Your MS word script will not use much, but this script will go very well me
Thanks
by jmeneses
10 Jan 2019, 01:54
Forum: Scripts and Functions
Topic: Word Enumerated Constants Search
Replies: 2
Views: 426

Re: Word Enumerated Constants Search

Hey burque505
Good job thanks!!
by jmeneses
07 Jan 2019, 03:12
Forum: Scripts and Functions
Topic: Just another INI-file object maker
Replies: 9
Views: 1256

Re: Just another INI-file object maker

good job I like sure I apply it :thumbup:
thanks for sharing
by jmeneses
07 Jan 2019, 02:01
Forum: Scripts and Functions
Topic: Just another INI-file object maker
Replies: 9
Views: 1256

Re: Just another INI-file object maker

Hi wolf_II
I get missing TreeBox function error, Is it some include?
Thanks!
by jmeneses
04 Jan 2019, 11:46
Forum: Ask For Help
Topic: Excel SaveAs PDF. HOW ?
Replies: 4
Views: 642

Re: Excel SaveAs PDF. HOW ?

This method ( ExportAsFixedFormat ) should be preferred over using SaveAs because it also allows specifying all PDF / XPS options. Note: This method has been added to the Excel object model with Excel 2007 and requires the Save as PDF or XPS Add-in for 2007 Microsoft Office programs to be installed...
by jmeneses
04 Jan 2019, 10:34
Forum: Ask For Help
Topic: Excel SaveAs PDF. HOW ?
Replies: 4
Views: 642

Re: Excel SaveAs PDF. HOW ?

Other, try type file 57

Code: Select all

XL.ActiveWorkbook.SaveAs("E:\" book_name ".pdf", 57)
by jmeneses
04 Jan 2019, 05:56
Forum: Ask For Help
Topic: Running macro in Excel PERSONAL.XLSB no longer working?
Replies: 2
Views: 421

Re: Running macro in Excel PERSONAL.XLSB no longer working?

Hello submeg I think the error occurs because the EXCEL is in edit mode, try this #If WinActive("ahk_class XLMAIN") q:: If (IsEditing()){ Msgbox 0x40000, % A_ThisFunc, % "EXCEL is EDITING!!" Return } Macro:= "PERSONAL.XLSB!MergeAndWrap" try xlApp := ComObjActive("Excel.Application") xlApp.Run(Macro)...

Go to advanced search