AutoHotkey Community

AlphaBravo

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

AlphaBravo

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

AlphaBravo

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

AlphaBravo

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.

AlphaBravo

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?

AlphaBravo

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

AlphaBravo

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

AlphaBravo

change to wb.Navigate(FilePath)

wb.Navigate(%FilePath%) means navigate to the contents of a variable whose name is saved in "FilePath"

AlphaBravo

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, "(?<=...

AlphaBravo

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

AlphaBravo

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

AlphaBravo

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

AlphaBravo

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

AlphaBravo

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
}

AlphaBravo

Code: Select all

xl.Selection.SpecialCells(xlCellTypeBlanks := 4).Select

ahk does not know what "xlCellTypeBlanks" is, you have to google "xlCellTypeBlanks enumeration"

AlphaBravo

got it, try using the code posted here to get mouse coordinates instead of SetTimer and MouseGetPos

AlphaBravo

your code is working for me, I just wanted to make sure your screen resolution is actually taller than 1050

AlphaBravo

silly question, what's your screen resolution set at?

AlphaBravo

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

AlphaBravo

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:"المؤمن...

Search found 494 matches

Re: EXCEL: find string of 9 or more digits

Re: Getting entire path of xml node Topic is solved

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

Re: Read COM3 Port Topic is solved

Re: HTML DOM

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

Re: IE navigate fails from Variable Topic is solved

Re: IE navigate fails from Variable Topic is solved

Re: HTML DOM

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

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

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

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

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

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

Re: Change Volume based on Mouse Position

Re: Any idea how can I do this

Re: Any idea how can I do this

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

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