AutoHotkey Community

Avastgard

In V2, the clipboard name is A_Clipboard Russ Thanks again! Here is the final code that will paste the VLookup result instead of displaying it on a MsgBox and allows you to choose the sheet to lookup: #Requires Autohotkey v2.0+ #SingleInstance force F10:: { needle := InputBox("Type Lookup value", "...

Avastgard

Inputbox with F12 as hotkey: f12:: { needle := InputBox("Lookup value?", "") needle := needle.value ;instead of needle := "matrix" xl := ComObject("Excel.Application") ;v1 ---> xl := ComObjCreate("Excel.Application") Workbook := xl.Workbooks.Open("C:\Users\xxxx\Documents\Spreadsheets\aaaa.xlsx") ra...

Avastgard

Inputbox with F12 as hotkey: f12:: { needle := InputBox("Lookup value?", "") needle := needle.value ;instead of needle := "matrix" xl := ComObject("Excel.Application") ;v1 ---> xl := ComObjCreate("Excel.Application") Workbook := xl.Workbooks.Open("C:\Users\xxxx\Documents\Spreadsheets\aaaa.xlsx") ra...

Avastgard

FWIW, I created a spreadsheet that matches the guidelines in @flyingDman's V2 example: name - vlookuptest.xlsx, 2 columns, 23 rows, cells in column A were junk text except for one entry "matrix" and just sequential integers in column B. I also changed the path in his code to point to my file. As lo...

Avastgard

Thanks for the code, flyingDman . However, I run into the same error message with the v2 version: Error: (0x800A03EC) Unable to obtain VLookup property from class WorksheetFunction Source: Microsoft Excel Specifically: VLookup 005: Workbook := xl.Workbooks.Open("C:\Users\flima\Desktop\lista CNPJs KB...

Avastgard

Do you want me to move this thread to the v2 section?

I would appreciate that. Thank you.

Avastgard

Oops, sorry guys. I remember reading this rule a while ago, but completely forgot about it. I deleted the AI-generated code from my question.

@boiler I honestly have no idea whether v1 or v2 are better suited for this use case. Now that the post has no code does it make a difference where it is?

Avastgard

I want to use an Excel spreadsheet to structure data that will be retrieved and pasted by an AutoHotkey script. In other words, I want to tell an AutoHotkey script to take a certain value given by the user (maybe typing it in an inputbox or GUI), look it up in a spreadsheet and return the value in t...

Avastgard

Saving the path is not needed. #Requires AutoHotkey v2+ #SingleInstance SetTitleMatchMode 2 loop { WinWaitActive "Save ahk_class #32770" if (explrPath:=get_Active_Explorer_Path())&&!InStr(explrPath, "{") { Send "!d" try While !ControlGetVisible("Edit2", "A") Continue While explrPath!=ControlGetText...

Avastgard

Saving the path is not needed. #Requires AutoHotkey v2+ #SingleInstance SetTitleMatchMode 2 loop { WinWaitActive "Save ahk_class #32770" if (explrPath:=get_Active_Explorer_Path())&&!InStr(explrPath, "{") { Send "!d" try While !ControlGetVisible("Edit2", "A") Continue While explrPath!=ControlGetText...

Avastgard

I want a script that will do the following: Run in the background and whenever an Explorer folder is activated, store that folder's filepath in a variable. If a new folder is activated, the new filepath replaces the previous one, so there is always just one filepath stored. Whenever the "Save as" wi...

Avastgard

Thanks as always, mikeyww , I believe this code will work on both monitors (only tested on home monitor, though): EDIT: tested on both ones and it works as intended. FuncF2(isHold, taps, state) { if (taps) { if (taps == 1) Send {F2} else if (taps == 2) { If (A_ScreenWidth == 2560) WinMove, ahk_class...

Avastgard

I use my notebook on two different monitors, one at home (2560x1080) and one at work (1920x1080). I modified evilC 's TapHoldManager script to make it so when I double tap F2, the last active windows explorer window gets placed in a certain position on the screen. Here is the code snippet: FuncF2(is...

Avastgard

[PLUGIN] GK OCR v1.1 (Win 10+ only) Usage: Select a clip text image and press Y to use built-in OCR of Windows 10+ to send text to the clipboard. how to install this plugin ? 1° download FG ScreenClipper v1.4+ at https://www.autohotkey.com/boards/viewtopic.php?p=506077#p506077 2° put GK_OCR.ahk plu...

Avastgard

Neat, thank you very much! Here is my final script that works as intended: #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. ; #Warn ; Enable warnings to assist with detecting common errors. SendMode Input ; Recommended for new scripts due to its superior speed ...

Avastgard

Thanks for the codes, mikeyww and andymbody ! They are both great! mikeyww , your code seems to suit me slightly better because it asks me to confirm the name of the new file in an inputbox. However, I can't seem to change fnSuffix := "-new" in line 2 to show current date and time in this format: yy...

Avastgard

I constantly have to work on files other people created and make changes to it. So every time I download the file, make a copy of it, rename it and then open the file to make changes. After some digging in the forums, I came up with this script that does part of the job, but doesn't change the name ...

Avastgard

@Avastgard There are different ways to do this. one good way is to use "GroupAdd" to group all of "ScreenClipper" windows, then use "GroupActivate". This would automatically activate the one below. Sorry I'm too busy to provide you with the code, but you should be able to figure it out by yourself ...

Avastgard

@SpeedMaster or @Flowgun:

Do you think it would be possible to add a hotkey to cycle through clipped images currently on screen? Having to click each one everytime I want to activate it is kind of bothersome

Thanks for your continued support for this amazing script.

Avastgard

New update for Draw Shape plugin: V. 2023 04 15 :arrow: https://www.autohotkey.com/boards/viewtopic.php?f=6&t=12088&p=517218#p517218 Added free hand drawing (Press Shift + Left mouse ) 8-) Shortcut to draw a line is moved to Shift + Right mouse Regards Sweet, thank you very much for this update! Is...

Search found 133 matches

Re: How to call a vlookup from AutoHotkey? Topic is solved

Re: How to call a vlookup from AutoHotkey? Topic is solved

Re: How to call a vlookup from AutoHotkey? Topic is solved

Re: How to call a vlookup from AutoHotkey? Topic is solved

Re: How to call a vlookup from AutoHotkey? Topic is solved

Re: How to call a vlookup from AutoHotkey? Topic is solved

Re: How to call a vlookup from AutoHotkey? Topic is solved

How to call a vlookup from AutoHotkey? Topic is solved

Re: How to store last active folder's filepath and paste it when the "Save as" window pops up

Re: How to store last active folder's filepath and paste it when the "Save as" window pops up

How to store last active folder's filepath and paste it when the "Save as" window pops up

Re: WinMove to position according detected monitor's resolution Topic is solved

WinMove to position according detected monitor's resolution Topic is solved

Re: Screen clipping

Re: Hotkey to copy file and paste with a different name Topic is solved

Re: Hotkey to copy file and paste with a different name Topic is solved

Hotkey to copy file and paste with a different name Topic is solved

Re: Screen clipping

Re: Screen clipping

Re: Screen clipping