Search found 75 matches

by AHK_user
08 Dec 2020, 14:22
Forum: Scripts and Functions
Topic: VBA to AHK Translator (Excel)
Replies: 12
Views: 1186

Re: VBA to AHK Translator (Excel)

Update: - Added the Acc.ahk library to the github files. - The constants.txt file will be automatically downloaded if not present. - Macro's will convert the function with the global option. This update is made based on the feedback of Joe Glines, thanks. https://www.youtube.com/watch?v=egaIZ9CB4LI&...
by AHK_user
22 Nov 2020, 06:47
Forum: Scripts and Functions
Topic: VBA to AHK Translator (Excel)
Replies: 12
Views: 1186

Re: VBA to AHK Translator (Excel)

Thanks very much, @AHK_user, great stuff. Perhaps this thread might be useful at some point, and jeeswg's list of all Office constants on GitHub . Regards, burque505 Thanks, I have added the other MS constants, so normally every constant should work now. Other updates: - Moved Constants.txt file to...
by AHK_user
18 Nov 2020, 17:01
Forum: Scripts and Functions
Topic: VBA to AHK Translator (Excel)
Replies: 12
Views: 1186

Re: VBA to AHK Translator (Excel)

Thanks for the replies. Nice work, please add also the mso constants like msoTrue => This is added to the file constants.txt. I could not find a clean list of the mso constants, so I just added the following: - msoCTrue = 1 - msoFalse = 0 - msoTriStateMixed = -2 - msoTriStateToggle = -3 - msoTrue = ...
by AHK_user
17 Nov 2020, 18:34
Forum: Tutorials
Topic: Manipulate VBA code in Excel
Replies: 1
Views: 627

Manipulate VBA code in Excel

Example code how to manipulate VBA code in an Excel file. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. #SingleInstance, Force ; Created by AHK_User ; Example code to read, delete, run or modify VBA code of an Excel file VBcode= ( Sub Anything() MsgBox("YEAH") End Sub ) glob...
by AHK_user
17 Nov 2020, 18:22
Forum: Scripts and Functions
Topic: VBA to AHK Translator (Excel)
Replies: 12
Views: 1186

VBA to AHK Translator (Excel)

The following small but powerfull code will (try to) translate VBA code to AHK Com Object code. The initial focus is to translate recorded VBA code, because it is more consistant and predictable generated, but it also works on cleanly written code. This script is still work in progress, If it failes...
by AHK_user
15 Sep 2020, 17:05
Forum: Scripts and Functions
Topic: WindowList - Viewer and manipulation of window data
Replies: 4
Views: 454

WindowList - Viewer and manipulation of window data

Here is the code for a viewer for used windows information, with functionalities to several autohotkey commands for windows. Functionalities: - Filters with radio buttons only visible windows and windows with titles - Allows to filter on strings with Edit fields above the list - Doubleclick on the w...
by AHK_user
18 Aug 2020, 16:50
Forum: Scripts and Functions
Topic: Extrapolate table values
Replies: 0
Views: 150

Extrapolate table values

Following script can be used to extrapolate table values. So it will try to look up the values in the table, and even if it is not present, it will try to predict the point based on points close by. This version will also will try to predict points outside the range. #NoEnv ; Recommended for perform...
by AHK_user
05 Jul 2020, 02:13
Forum: Ask For Help
Topic: WinActivate on Chrome tabs
Replies: 6
Views: 2764

Re: WinActivate on Chrome tabs

For the latest chrome, I made some modifications to make it work: ChromeActivate(SearchText, AccPath_TabList := "4.1.2.1.1.1") { TabList := Acc_Get("Object", AccPath_TabList, 0, "ahk_class Chrome_WidgetWin_1") Loop, % Acc_Children(TabList).MaxIndex() { _tab := Acc_Child(TabList, A_Index) tabTitle :=...
by AHK_user
01 Jul 2020, 13:13
Forum: Gaming
Topic: New to AHK. Trying to figure out how to make a GUI visible.
Replies: 2
Views: 1096

Re: New to AHK. Trying to figure out how to make a GUI visible.

This script seems to result in a visible gui, so I do not understand the problem.
by AHK_user
01 Jul 2020, 13:04
Forum: Ask For Help
Topic: Advice: Abstracting a Program GUI as a Class?
Replies: 2
Views: 1291

Re: Advice: Abstracting a Program GUI as a Class?

In this post you find a few examples, including mine that makes it simple to add tooltip and statusbar responses to the controls.
https://www.autohotkey.com/boards/viewtopic.php?f=76&t=68912&start=20
by AHK_user
29 Jun 2020, 13:40
Forum: Scripts and Functions
Topic: Ixiko's collections of functions and libraries
Replies: 27
Views: 11508

Re: Ixiko's collections of functions and libraries

Extreme interesting collection and very nicely documented :bravo:
It will take a while to study this.

Maybe an idea to add some extra buttons in the AHK-Rara_TheGui to let users add missing examples and descriptions en send the data to you to update the documentation of the functions.
by AHK_user
22 Jun 2020, 14:28
Forum: Ask For Help
Topic: Excel COM objects and sharepoint
Replies: 0
Views: 328

Excel COM objects and sharepoint

Does anybody has some experience with using COM objects in an excel file that is edited by multiple users? At my work, we use an excel with sharepoint that we edit at the same time, but as a result we disconnect a lot. So we get a message that the file is not syncronized anymore and needs to be clos...
by AHK_user
20 Jun 2020, 11:50
Forum: Ask For Help
Topic: Autohotkey in Excel
Replies: 9
Views: 2632

Re: Autohotkey in Excel

I think the correct code is: Send ^gG14{Enter}^c But I would recommend a different approach, the use of com objects gives a lot of control, flexibility and speed: oExcel := Excel_Get() MsgBox, % oExcel.ActiveWorkbook.ActiveSheet.Range("G14").value return Excel_Get(WinTitle="ahk_class XLMAIN") { ; by...
by AHK_user
11 Mar 2020, 15:13
Forum: Gaming
Topic: *.ini file <=> *.ahk Topic is solved
Replies: 4
Views: 820

Re: *.ini file <=> *.ahk Topic is solved

Here is a working example: #SingleInstance, Force SetWorkingDir %A_ScriptDir% iniFile = Temp.ini IniRead, V_Input1, %iniFile%, Section, Input1 IniRead, V_Input2, %iniFile%, Section, Input2 IniRead, V_Input3, %iniFile%, Section, Input3, No Gui, Add, Text, x12 y9 w360 h40, > AutoHotKey Forum < try to ...
by AHK_user
09 Mar 2020, 06:21
Forum: Ask For Help
Topic: Keep my code safe from casual coders
Replies: 6
Views: 866

Re: Keep my code safe from casual coders

I haven't tried/tested it, but you could try AHK Dynamic Obfuscator L by DigiDon:
https://www.autohotkey.com/boards/viewtopic.php?f=6&t=49887&hilit=encrypt+code
by AHK_user
02 Mar 2020, 06:20
Forum: Ask For Help
Topic: Combing Keys
Replies: 7
Views: 444

Re: Combing Keys

I spotted a mistake in my latest code, maybe this will fix it: I reccomend you to do some errorchecking, like adding simple MsgBox functions to check if the script is behaving as you woud predict. These can be removed if you verified that it works. #SingleInstance, Force global Toggle_F11:=1 ;#IfWin...
by AHK_user
01 Mar 2020, 16:13
Forum: Ask For Help
Topic: Combing Keys
Replies: 7
Views: 444

Re: Combing Keys

Strange, normally you could "reset" your key states by pressing the Ctrl and Mbutton once (to tell your system to release them). What is the name of your CAD program? You could try a different method, not checking the keystates, but tolling with a variable: #SingleInstance, Force global Toggle_F11:=...
by AHK_user
01 Mar 2020, 10:52
Forum: Ask For Help
Topic: Reading mdb files - Microsoft Data Base Access Topic is solved
Replies: 4
Views: 901

Re: Reading mdb files - Microsoft Data Base Access Topic is solved

Thanks a lot, it seemed indeed that Microsoft Access Database Engine 2010 Redistributable was missing :thumbup: This helped me to start the connection. Here is a simple example how you can loop trough the data: #SingleInstance, Force ; to use this, please download "Microsoft Access Database Engine 2...
by AHK_user
01 Mar 2020, 02:32
Forum: Ask For Help
Topic: Combing Keys
Replies: 7
Views: 444

Re: Combing Keys

This code should work.

Code: Select all

#SingleInstance, Force

;#IfWinActive, Ahk_exe Program.exe
F11::
if (GetKeyState("Ctrl") = "D" or GetKeyState("MButton") = "D"){
	SendInput,  {Ctrl Up}{MButton Up}
}
else{
	SendInput,  {Ctrl Down}{MButton Down}
}
return

Go to advanced search