Search found 494 matches

by AlphaBravo
Today, 18:03
Forum: Ask For Help
Topic: EXCEL: find string of 9 or more digits
Replies: 8
Views: 124

Re: EXCEL: find string of 9 or more digits

great guys, that helps! thank you :) But I met another problem :)) some of the Excel files has Passwords on it. I want just skip that kind of Excel files use open method with password set to anything "other than the actual password" and try to open it, if it fails then skip it. _ := ComObjMissing()...
by AlphaBravo
28 Oct 2020, 12:58
Forum: Ask For Help
Topic: Getting entire path of xml node Topic is solved
Replies: 4
Views: 100

Re: Getting entire path of xml node Topic is solved

this code may need some clean up but will get you started data = ( <?xml version="1.0"?> <root> <parent-1> </parent-1> <parent-2> <child-1> <grandchild-1> <n>Value1</n> </grandchild-1> <grandchild-2> <n>Value2</n> </grandchild-2> </child-1> <child-2> </child-2> </parent-2> </root> ) xmlDoc := ComObj...
by AlphaBravo
27 Oct 2020, 09:54
Forum: Ask For Help
Topic: Removing odd-numbered keys from an array Topic is solved
Replies: 8
Views: 117

Re: Removing odd-numbered keys from an array Topic is solved

mikeyww , I see a possible flaw using Until !Array[A_Index + 1] in case one of the odd array values is set to 0 here is my solution: Array := ["Item1", "Item2", "Item3", "Item4", 0, "Item6", "Item7", "Item8", "Item9", "Item10", "Item11", "Item12", "Item13"] Num := Ceil(Array.count()/2) loop, % num ...
by AlphaBravo
02 Sep 2020, 09:56
Forum: Ask For Help
Topic: Read COM3 Port Topic is solved
Replies: 4
Views: 170

Re: Read COM3 Port Topic is solved

The script posted here looks promising, I briefly tested an output on Pin 4 DTR and it worked, 7 volts or so to ground (Pin 5), I don't have small jumpers at the moment to test inputs, please check it and report if it works for you.
obviously you need to replace "COM2" with "COM3" in your case.
by AlphaBravo
29 Aug 2020, 12:42
Forum: Ask For Help
Topic: HTML DOM
Replies: 42
Views: 1173

Re: HTML DOM

majstang wrote:
29 Aug 2020, 12:37
AlphaBravo, when using your RegEx on the whole html source (imdb.html) it seems to fail, while mine is still operational. How come? I updated script in post 1.
did you notice I used sub-pattern 1 as in Imdb_Poster1 and not Imdb_Poster?
by AlphaBravo
29 Aug 2020, 12:40
Forum: Ask For Help
Topic: Display a message if for 5 seconds no key is pressed Topic is solved
Replies: 3
Views: 114

Re: Display a message if for 5 seconds no key is pressed Topic is solved

Gregorian wrote:
29 Aug 2020, 12:20
Thank you. But when i close the message box, it appears again.
How can I do it so the message box only appears once?
Press Enter to clear MsgBox and reset A_TimeIdleKeyboard
I'll think of a different way!
OK, use A_TimeIdle instead of A_TimeIdleKeyboard
by AlphaBravo
29 Aug 2020, 11:56
Forum: Ask For Help
Topic: IE navigate fails from Variable Topic is solved
Replies: 5
Views: 189

Re: IE navigate fails from Variable Topic is solved

the following code runs for me, save an html file to your desktop, and run this simple code

Code: Select all

wb := ComObjCreate("InternetExplorer.Application")
wb.Visible := True
filePath = File:\\%A_Desktop%\IE navigate fails from Variable - AutoHotkey Community.html
wb.Navigate(filePath)
return
by AlphaBravo
29 Aug 2020, 11:30
Forum: Ask For Help
Topic: IE navigate fails from Variable Topic is solved
Replies: 5
Views: 189

Re: IE navigate fails from Variable Topic is solved

change to wb.Navigate(FilePath)

wb.Navigate(%FilePath%) means navigate to the contents of a variable whose name is saved in "FilePath"
by AlphaBravo
29 Aug 2020, 11:29
Forum: Ask For Help
Topic: HTML DOM
Replies: 42
Views: 1173

Re: HTML DOM

your regex works and so is my simple approach Response = <img alt="Wonder Woman Poster" title="Wonder Woman Poster" src="https://m.media-amazon.com/images/M/MV5BNDFmZjgyMTE[email protected]@._V1_UX182_CR0,0,182,268_AL_.jpg" /> RegExMatch(Response, "(?<=...
by AlphaBravo
29 Aug 2020, 11:04
Forum: Ask For Help
Topic: Display a message if for 5 seconds no key is pressed Topic is solved
Replies: 3
Views: 114

Re: Display a message if for 5 seconds no key is pressed Topic is solved

approach 1 : running at full speed all the time #InstallKeybdHook CheckKeyboard: while (A_TimeIdleKeyboard < 5000) continue MsgBox gosub, CheckKeyboard return approach 2 : using a timer every 50 ms #InstallKeybdHook SetTimer, CheckKeyboard, -50 return CheckKeyboard: if (A_TimeIdleKeyboard > 5000) Ms...
by AlphaBravo
29 Aug 2020, 10:46
Forum: Ask For Help
Topic: Compare Excel file and make a list of new value
Replies: 7
Views: 298

Re: Compare Excel file and make a list of new value

flyingDman , I totally agree SafeArray would be a faster approach however your code is comparing row to row - which maybe what the OP is asking for - it's just not what I understood from reading his request : (value not found in the previous file.xls) my approach finds values in newer file not foun...
by AlphaBravo
27 Aug 2020, 23:08
Forum: Ask For Help
Topic: Compare Excel file and make a list of new value
Replies: 7
Views: 298

Re: Compare Excel file and make a list of new value

this code is based on the assumption that Column "A" does not have gaps on any of your excel sheets, it will find values listed on newest "file.xls" not found on previous "file.xls" SetBatchLines, -1 Filelist := "" Loop, Files, % A_Desktop "\Folder\*.*", FR ; Change "A_Desktop" to your desired folde...
by AlphaBravo
21 Aug 2020, 21:28
Forum: Ask For Help
Topic: Switch to another file without adding the file name on the script Topic is solved
Replies: 5
Views: 607

Re: Switch to another file without adding the file name on the script Topic is solved

mcubac08 wrote:
21 Aug 2020, 15:37
A2 and I28 is the range...
Where do i need to copy your script within mine? or is that the whole script?
Sorry I am new with autohotkey and i am not sure about the logic yet
Thanks!
that is the whole script, just add your hotkey and a return at the end
by AlphaBravo
21 Aug 2020, 12:51
Forum: Ask For Help
Topic: Switch to another file without adding the file name on the script Topic is solved
Replies: 5
Views: 607

Re: Switch to another file without adding the file name on the script Topic is solved

not sure what y is in xl.range("A2" y ":I28") !!

Code: Select all

pth := "C:\Users\USERNAME\Desktop\BOOK1.xlsx"
xl.Workbooks.Open(Pth)
master := xl.ActiveWorkBook
for wb in xl.Workbooks
{
	if (wb.name <> master.name)
		wb.ActiveSheet.range("A2:I28").Value := master.ActiveSheet.range("A2:I28").Value
}
by AlphaBravo
19 Aug 2020, 13:06
Forum: Ask For Help
Topic: How to convert these VBA codes into AHK codes for selecting only the blank cells in MS Excel? Topic is solved
Replies: 2
Views: 89

Re: How to convert these VBA codes into AHK codes for selecting only the blank cells in MS Excel? Topic is solved

Code: Select all

xl.Selection.SpecialCells(xlCellTypeBlanks := 4).Select
ahk does not know what "xlCellTypeBlanks" is, you have to google "xlCellTypeBlanks enumeration"
by AlphaBravo
18 Aug 2020, 14:50
Forum: Ask For Help
Topic: Change Volume based on Mouse Position
Replies: 5
Views: 1267

Re: Change Volume based on Mouse Position

got it, try using the code posted here to get mouse coordinates instead of SetTimer and MouseGetPos
by AlphaBravo
17 Aug 2020, 12:30
Forum: Ask For Help
Topic: Change Volume based on Mouse Position
Replies: 5
Views: 1267

Re: Any idea how can I do this

your code is working for me, I just wanted to make sure your screen resolution is actually taller than 1050
by AlphaBravo
17 Aug 2020, 12:25
Forum: Ask For Help
Topic: Change Volume based on Mouse Position
Replies: 5
Views: 1267

Re: Any idea how can I do this

silly question, what's your screen resolution set at?
by AlphaBravo
16 May 2020, 21:19
Forum: Ask For Help
Topic: How to convert numbers to Arabic numerals Topic is solved
Replies: 13
Views: 623

Re: How to convert numbers to Arabic numerals Topic is solved

it messes up the quotation. which quotation? how is it messed up? I can't test it because I don't have any foreign keyboards or other languages installed, but you may want to try A_Language to setup different "quotation" based on your keyboard if (A_Language = 0409) MsgBox % "English_United_States"...
by AlphaBravo
16 May 2020, 14:05
Forum: Ask For Help
Topic: How to convert numbers to Arabic numerals Topic is solved
Replies: 13
Views: 623

Re: How to convert numbers to Arabic numerals Topic is solved

hope it helps db := {1:"الفاتحة", 2:"البقرة", 3:"آل عمران", 4:"النساء", 5:"المائدة", 6:"الأنعام", 7:"الأعراف", 8:"الأنفال", 9:"التوبة", 10:"يونس" ,11:"هود", 12:"يوسف", 13:"الرعد", 14:"إبراهيم", 15:"الحجر", 16:"النحل", 17:"الإسراء", 18:"الكهف", 19:"مريم", 20:"طه" ,21:"الأنبياء", 22:"الحج", 23:"المؤمن...

Go to advanced search