Search found 1207 matches

by FanaticGuru
12 Nov 2018, 12:38
Forum: Scripts and Functions
Topic: Hotkey Help - Display Active AHK Hotkeys and Hotstrings
Replies: 41
Views: 15595

Re: FIND BOX issues

Let me begin by saying your new FIND function is awesome. Your code is to be admired. I also think your script should be showcased. I do, however, have a few problems/issues/suggestions as per the FIND function. And, yes, I realize it is new, so you may have already considered some of things I have...
by FanaticGuru
09 Nov 2018, 18:59
Forum: Scripts and Functions
Topic: Hotkey Help - Display Active AHK Hotkeys and Hotstrings
Replies: 41
Views: 15595

Re: Hotkey Help - Display Active AHK Hotkeys and Hotstrings

Thanks for the update, FG. I believe this code is missing from the page at the link on page 1 of this topic. I added it back in and it works: AHKScripts(ByRef Array) { DetectHiddenWindows, % (Setting_A_DetectHiddenWindows := A_DetectHiddenWindows) ? "On" : WinGet, AHK_Windows, List, ahk_class AutoH...
by FanaticGuru
09 Nov 2018, 16:30
Forum: Ask For Help
Topic: Excel COM - pull variable from other function variable??
Replies: 2
Views: 92

Re: Excel COM - pull variable from other function variable??

So the last part, when saving. I give the user the option to select saving their file as a .xlsx and .xlsm, but my problem is that I don't know what to set the SaveAs FileFormat variable as? I'm not sure if this gets recorded in the fileToSave variable in some way, although I suspect that it does. ...
by FanaticGuru
09 Nov 2018, 15:44
Forum: Scripts and Functions
Topic: Hotkey Help - Display Active AHK Hotkeys and Hotstrings
Replies: 41
Views: 15595

Re: Hotkey Help - Display Active AHK Hotkeys and Hotstrings

Updated in First Post Change Log: Version 2.94 (2018-10-22) Added a "Find" command to find text within the Help dialog. When the Help dialog is active, Control+f will bring up the Find box. This is done through a class called SearchEdit which is written in a generic way that could be used with othe...
by FanaticGuru
08 Nov 2018, 19:26
Forum: Scripts and Functions
Topic: Hotkey Help - Display Active AHK Hotkeys and Hotstrings
Replies: 41
Views: 15595

Re: Hotkey Help - Display Active AHK Hotkeys and Hotstrings

this script fails when the script being examined is named "numpadmouse". Any close variation to that works fine. It shows the script but does not display it's hotkeys. I can't replicate this problem. It works fine for me. 1:: ; <-- Hey Hey MsgBox test return I save this script as numpadmouse.ahk an...
by FanaticGuru
29 Oct 2018, 12:54
Forum: Scripts and Functions
Topic: [Library] Sift - Fuzzy Search by RegEx and Ngram
Replies: 17
Views: 3985

Re: [Library] Sift - Fuzzy Search by RegEx and Ngram

#Include Sift.ahk :*:searchword:: InputBox, SearchText, Search for, Search for Keyword ;Loop, Parse, Data, `n, `r ;FileRead, Data, C:\myfile.ahk ;Data = "C:\myfile.ahk" FileRead, Data, C:\myfile.ahk MsgBox % Sift_Ngram(Data, %SearchText%) Return I'm trying to search a file(s) (more than one is even...
by FanaticGuru
26 Oct 2018, 13:56
Forum: Ask For Help
Topic: Issue combining scripts
Replies: 13
Views: 323

Re: Issue combining scripts

I don't use a Mac so I don't really not what you want your end result to be. But maybe this will help you to understand what is happening: RCtrl::RWin RWin::RCtrl LCtrl::LWin LWin::LCtrl ; ^^^^^ Above does not effect Below vvvvv LCtrl & q:: LCtrl & Tab:: LWin & q:: LWin & Tab:: ToolTip You pressed %...
by FanaticGuru
26 Oct 2018, 01:52
Forum: Ask For Help
Topic: Issue combining scripts
Replies: 13
Views: 323

Re: Issue combining scripts - PLEASE HELP!

When I combine them though, like this, it no longer works: RCtrl::RWin RWin::RCtrl LCtrl::LWin LWin::LCtrl LWin & Q::Send !{f4} LWin & Tab:: AltTab RWin & BS::Send {Del} ^h::send #d You are probably creating situations where one hotkey is triggering another hotkey. Creating loops and unpredicted be...
by FanaticGuru
25 Oct 2018, 13:27
Forum: Ask For Help
Topic: How to control Excel with AHK
Replies: 10
Views: 244

Re: How to control Excel with AHK

Thank you, trying to more understand. I did following syntax and it does not work. What could be wrong? No errors from AHK. Object oW is created but then nothing will happen. oW := ComObjActive("Excel.Application") Sleep, 500 oW.Protect("password",true,true) Like has been stated you are trying to p...
by FanaticGuru
24 Oct 2018, 12:15
Forum: Ask For Help
Topic: How to control Excel with AHK
Replies: 10
Views: 244

Re: How to control Excel with AHK

Thanks a lot, Guru. This is something I had found. The problem I have is then the syntax. Usually, the code is for VB and not working in AHK ... still giving some errors or unknown. For example this: "Protect workbook structure". (You can find it under File/Info tab) VBA syntax is following: Active...
by FanaticGuru
24 Oct 2018, 00:45
Forum: Ask For Help
Topic: Script to Change Output Based on Month Specified By User - Excel COM Topic is solved
Replies: 4
Views: 118

Re: Script to Change Output Based on Month Specified By User - Excel COM Topic is solved

Here is a starting concept that might be useful. InputBox, Month, Month, Enter Month to Search for? xlApp := ComObjActive("Excel.Application") Row := xlApp.Range("B44:B55").Find(Month).Row xlApp.Range("E" Row-1 ":M" Row-1).AutoFill(xlApp.Range("E" Row-1 ":M" Row)) xlApp.Range("K" Row).Value := "-" x...
by FanaticGuru
23 Oct 2018, 18:34
Forum: Ask For Help
Topic: Script to Change Output Based on Month Specified By User - Excel COM Topic is solved
Replies: 4
Views: 118

Re: Script to Change Output Based on Month Specified By User - Excel COM Topic is solved

You need to break your problem down to one specific task that you need help with. I assume your problem is that you want to copy information from one sheet to another but each month you need to copy from a different range to a different range. I know you are doing multiple copies from one place to a...
by FanaticGuru
23 Oct 2018, 11:41
Forum: Ask For Help
Topic: How to control Excel with AHK
Replies: 10
Views: 244

Re: How to control Excel with AHK

Yes, I looked and used some of the codes but what I am looking for is a complete list of excel parameters I can automate with correct syntax. This is something I am not able to find anywhere. The Microsoft MSDN for Excel contains all the properites, methods, and events of the Excel COM object. http...
by FanaticGuru
22 Oct 2018, 18:57
Forum: Ask For Help
Topic: Using AHK and Excel's COM
Replies: 1
Views: 61

Re: Using AHK and Excel's COM

Hi folks, I've been dinging around with COM in Excel for the last couple of weeks and the more I learn, the more complex and difficult each problem I am trying to solve becomes. I've looked at countless forum posts on COM in Excel, many with varying techniques to do essentially the same thing. Seem...
by FanaticGuru
18 Oct 2018, 14:39
Forum: Ask For Help
Topic: From Notepad to Word .doc and back Topic is solved
Replies: 7
Views: 164

Re: From Notepad to Word .doc and back Topic is solved

An interesting idea to use Word to spell check in other applications. Here is my take on it. OnExit, Word_Shutdown #F12:: Clipboard := "" Send ^c ClipWait if !IsObject(wdApp) wdApp := ComObjCreate("Word.Application") if !IsObject(wdDoc) wdDoc := wdApp.Documents.Add wdDoc.Content.Text := Clipboard No...
by FanaticGuru
17 Oct 2018, 17:18
Forum: Ask For Help
Topic: Value of a Excel cell in selected row
Replies: 4
Views: 110

Re: Value of a Excel cell in selected row

#SingleInstance, Force oExcel := ComObjActive("Excel.Application") RegExMatch(oExcel.ActiveCell.Address, "\d+", Row) Value := oExcel.Range("B" Row).Value URL := oExcel.Range("C" Row).Text MsgBox, % Value Run, % URL You can avoid the string manipulation like this: oExcel := ComObjActive("Excel.Appli...
by FanaticGuru
17 Oct 2018, 12:52
Forum: Scripts and Functions
Topic: [Library] Sift - Fuzzy Search by RegEx and Ngram
Replies: 17
Views: 3985

Re: [Library] Sift - Fuzzy Search by RegEx and Ngram

There's no interference with other programs and certainly no negative consequences. That is not true. Two quotes from the documentation: Determines how fast a script will run (affects CPU utilization). For example, on most systems a setting of 10ms will prevent the script from using any more than 5...
by FanaticGuru
11 Oct 2018, 12:53
Forum: Ask For Help
Topic: Excell Cell offset
Replies: 4
Views: 118

Re: Excell Cell offset

Hello, Thank you for the help here. Your script ran fine when I tab through the cells without entering data but when I add data and then try tabbing to the next cell I get a error message. "Error 0X8001000 - Call was rejected by callee. Specifically: ActiveCell. Then there is a arrow pointing to th...
by FanaticGuru
10 Oct 2018, 15:02
Forum: Ask For Help
Topic: Sørensen–Dice coefficient Topic is solved
Replies: 10
Views: 196

Re: Sørensen–Dice coefficient Topic is solved

Normally I would use the Levenshtein Distance. For this one I would probably collect the bigrams of both strings in seperate arrays and then compare the arrays. sharedBigrams := 0 for bigram, _ in bigramsOfFirstWord { if bigramsofSecondWord.hasKey(bigram) { sharedBigrams++ } } If people want to pla...
by FanaticGuru
10 Oct 2018, 13:31
Forum: Ask For Help
Topic: Excell Cell offset
Replies: 4
Views: 118

Re: Excell Cell offset

Code: Select all

$Tab::
	xlApp := ComObjActive("Excel.Application")
	if (xlApp.ActiveCell.Column = 7)
		xlApp.ActiveCell.Offset(1,-3).Activate
	else
		Send {Tab}
return
FG

Go to advanced search