Search found 1220 matches

by FanaticGuru
26 Oct 2018, 01:52
Forum: Ask For Help
Topic: Issue combining scripts
Replies: 13
Views: 440

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: 295

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: 295

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: 163

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: 163

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: 295

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: 72

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: 186

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: 133

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: 4100

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: 137

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: 211

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: 137

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
by FanaticGuru
09 Oct 2018, 22:40
Forum: Ask For Help
Topic: How to check focused control changes with OnMessage() rather than gLabel SetTimer? Topic is solved
Replies: 14
Views: 342

Re: How to check focused control changes with OnMessage() rather than gLabel SetTimer? Topic is solved

After testing your great options tonight, this is a comparative test simplifying both methods side by side. To compare one or the other, all you have to do is comment out either the DllCall or the OnMessage() I still don't know which one of the two I prefer but for your information, here is the com...
by FanaticGuru
09 Oct 2018, 19:05
Forum: Ask For Help
Topic: AHK To Work IN-GAME Only
Replies: 24
Views: 615

Re: AHK To Work IN-GAME Only

If you want to send commands to another window than the one that is currently active then you need ControlSend.

This will allow you to work in one window while AHK sends commands to another window.

FG
by FanaticGuru
09 Oct 2018, 11:26
Forum: Ask For Help
Topic: How to check focused control changes with OnMessage() rather than gLabel SetTimer? Topic is solved
Replies: 14
Views: 342

Re: How to check focused control changes with OnMessage() rather than gLabel SetTimer? Topic is solved

Microsoft docs: Message Source wParam (high word) wParam (low word) lParam Control Control-defined notification code Control identifier Handle to the control window Is the wParam Low Word (control identifier) any useful? Would you be able to use any of these without defining hWnd and only using GUI...
by FanaticGuru
08 Oct 2018, 21:46
Forum: Ask For Help
Topic: How to check focused control changes with OnMessage() rather than gLabel SetTimer? Topic is solved
Replies: 14
Views: 342

Re: How to check focused control changes with OnMessage() rather than gLabel SetTimer? Topic is solved

I can't find what Windows Message is relevant to checking for currently focused control in the active window, and if there is such an option. So for now I am using a SetTimer gLabel repeating every 30ms to do that. But how would you use OnMessage() to do this instead of a Timer Loop? Below is an ex...
by FanaticGuru
05 Oct 2018, 17:39
Forum: Ask For Help
Topic: Txt file containing HTML code to extract data from Excel.
Replies: 3
Views: 132

Re: Txt file containing HTML code to extract data from Excel.

Assuming the text is proper html then you can put the html code into an HTML object and then use DOM to get information from the table the same as you would with a webpage. Below is an example: html = (join <table><tr style="background-color:#F3F2F2;"> <td><a href="javascript:void(0);" data-id="0370...
by FanaticGuru
05 Oct 2018, 15:17
Forum: Ask For Help
Topic: Is this general idea possible?
Replies: 7
Views: 269

Re: Is this general idea possible?

This is not exactly what you need but it is an example of using WinHttpRequest to write an HTML object that you can then use DOM to get information from that HTML object. ; create blank HTML file object oHTML := ComObjCreate("HTMLfile") ; Get the HTML text from a Http and put into the HTML object oH...
by FanaticGuru
04 Oct 2018, 14:27
Forum: Ask For Help
Topic: Excel Spreadsheet automation...please help! Topic is solved
Replies: 7
Views: 199

Re: Excel Spreadsheet automation...please help! Topic is solved

Here is my issue. I have a spreadsheet put into the same directory every day that is named ML NORTHEAST_FOODS_*.xls where the * references an 8 digit date. Today, it was 20181003. I also cannot get the script to intelligently pull the filename from the directory since the filename changes every day...

Go to advanced search