Search found 1476 matches

by FanaticGuru
Yesterday, 12:33
Forum: Ask For Help
Topic: AHK allow only to run on specific hdd serial Topic is solved
Replies: 13
Views: 232

Re: AHK allow only to run on specific hdd serial Topic is solved

Kind of funny that someone that barely understands AHK thinks their script is so great that it would be pirated. And that this "copy protection" can be foiled by any text editor like Notepad. I guess it would protect your script from someone that does not know how to use Google. Like two blind peopl...
by FanaticGuru
21 Oct 2020, 11:39
Forum: Ask For Help
Topic: Website Username & Passwords (IE/Chrome) Topic is solved
Replies: 12
Views: 235

Re: Website Username & Passwords (IE/Chrome) Topic is solved

Any idea on how to address the issue in my last post? The Return is the end of the hotkey. You have to put everything you want the hotkey to do between the hotkey define and the return. ^l:: ; <-- Start of Hotkey WinGetActiveTitle, Title Switch Title { Case "Box | Login - Internet Explorer": USERNA...
by FanaticGuru
20 Oct 2020, 19:46
Forum: Ask For Help
Topic: Recording Macros for AHK
Replies: 2
Views: 53

Re: Recording Macros for AHK

If you need something more robust, there is Pulover's Macro Creator.
https://www.autohotkey.com/boards/viewforum.php?f=63

FG
by FanaticGuru
20 Oct 2020, 18:43
Forum: Ask For Help
Topic: Run VBA Macros from a Workbook when another Workbook is in focus
Replies: 1
Views: 36

Re: Run VBA Macros from a Workbook when another Workbook is in focus

Xl.Run("Macros1") only works when the specific Workbook it's in is in focus. I have tried variations of specifying the file in the Macros path, ie Xl.Run("Automation.xlsm!Macros1"), and can only get either working by putting a WinActivate function before it. However I would prefer to allow my users...
by FanaticGuru
14 Oct 2020, 14:57
Forum: Ask For Help
Topic: Website Username & Passwords (IE/Chrome) Topic is solved
Replies: 12
Views: 235

Re: Website Username & Passwords (IE/Chrome) Topic is solved

login := {} ; Add new logins as needed; nTabs is number of TABs to send between user name and password login.Box := {user: "Joe", pwd: "[email protected]", nTabs: 1} login.AutoHotkey := {user: "BigJoe", pwd: "[email protected]", nTabs: 2} Return F3:: WinGetActiveTitle, winTitle RegExMatch(winTitle, "[^\s]+", firstW...
by FanaticGuru
13 Oct 2020, 17:54
Forum: Ask For Help
Topic: Website Username & Passwords (IE/Chrome) Topic is solved
Replies: 12
Views: 235

Re: Website Username & Passwords (IE/Chrome) Topic is solved

I have a script that I have used for years (that I did not create) for a specific application to automatically enter my username and password. I use "Ctrl+L" to enter this information. I am not need to do the same thing (and would like to use the same key combination) to enter this information once...
by FanaticGuru
13 Oct 2020, 12:48
Forum: Ask For Help
Topic: How to simply encrypt a piece of text without using a password? Topic is solved
Replies: 13
Views: 2333

Re: How to simply encrypt a piece of text without using a password? Topic is solved

I use AHK scripts everyday with encryption that is based on unique properties of my computer so that the scripts will only execute correctly on my computer. The unique properties of my computer is the key to the encryption. The scripts have lots of secret stuff but I never have to enter a password ...
by FanaticGuru
13 Oct 2020, 12:45
Forum: Ask For Help
Topic: Excel Conditional Formatting
Replies: 4
Views: 161

Re: Excel Conditional Formatting

found solution on following link https://stackoverflow.com/questions/27579771/how-to-create-text-contains-formattingconditional-format-condition-for-excel but I was confuse how to define type.missing into AHK, I know "FormatConditions.Add(9,,,, "PASS", 0,,)" gona through error so I just set them em...
by FanaticGuru
09 Oct 2020, 19:47
Forum: Ask For Help
Topic: Excel Conditional Formatting
Replies: 4
Views: 161

Re: Excel Conditional Formatting

I can't figure out how to convert this Excel macro to AutoHotkey COM Object code. Home > Conditional Formatting > Highlight Cell Rules > Text That Contains... > Format cells that contain the text "PASS" with "Green Fill with Dark Green Text". I want to add the condition to a specific column where t...
by FanaticGuru
09 Oct 2020, 11:39
Forum: Ask For Help
Topic: Retrieving the Content of All Messages in Outlook in Order
Replies: 7
Views: 131

Re: Retrieving the Content of All Messages in the Outtlok in Order

It looks like it only checks a single folder. I could not find where the problem was caused. It would be good to be able to receive the sending receiver part of the mail. You can debug some by putting in a line just to display the names of the folders it is looping through. olApp := ComObjActive("O...
by FanaticGuru
09 Oct 2020, 11:24
Forum: Ask For Help
Topic: Excel Workbook Copy To Topic is solved
Replies: 10
Views: 212

Re: Excel Workbook Copy To Topic is solved

For me doesn't work.     https://i.imgur.com/kQbMfHV.jpg   Error: wrong index. It looks like the error is related to an invalid file name. Your picture has some non-english letters in it so I am guessing this is something to do with language localization. Could have something to do with file coding...
by FanaticGuru
08 Oct 2020, 19:53
Forum: Ask For Help
Topic: Excel Workbook Copy To Topic is solved
Replies: 10
Views: 212

Re: Excel Workbook Copy To Topic is solved

I have a few different CSV files I want to merge into a single Excel Workbook, with the contents of each CSV file on a separate WorkSheet. This will combine all the sheets from multiple Excel files, regardless of whether they are csv or xlsx. Each workbook can have multiple sheets, they will all be...
by FanaticGuru
08 Oct 2020, 19:34
Forum: Ask For Help
Topic: Excel Workbook Copy To Topic is solved
Replies: 10
Views: 212

Re: Excel Workbook Copy To Topic is solved

I'm using AutoHotkey to create an Excel Workbook. If I manually open an existing Workbook, and try to copy a Worksheet to the Workbook created with AutoHotkey, I can't. The AHK Excel Workbook doesn't show as an available option to copy to. Post your code. This should all be very doable. It is possi...
by FanaticGuru
08 Oct 2020, 14:42
Forum: Ask For Help
Topic: Script to Quickly add entries to existing AHK script
Replies: 4
Views: 126

Re: Script to Quickly add entries to existing AHK script

[section]Thank you for coming to our presentation. We plan to have another one on October 9 fwiw::for what it's worth{ Would it suit you tc::to come{ then as well? [/section] Here is a start. Loop { Input, SingleKey, L1 V, :{Space}{Return} if (ErrorLevel = "Max") { Log .= SingleKey continue } if (E...
by FanaticGuru
08 Oct 2020, 11:57
Forum: Ask For Help
Topic: Retrieving the Content of All Messages in Outlook in Order
Replies: 7
Views: 131

Re: Retrieving the Content of All Messages in the Outtlok in Order

I am not thinking of instant scanning. I will scan to SQLite Database and query with FTS5. Speeds are quite acceptable. (Even if it's maybe 100 thousand emails.) All I need is to transfer the mails from outlook to the database and to continue the transfer process with a ahk application working in t...
by FanaticGuru
06 Oct 2020, 15:07
Forum: Ask For Help
Topic: String parsing peeking at the next character.
Replies: 9
Views: 166

Re: String parsing peeking at the next character.

I thought looking at each character would be easier than some monstrous regex. I'll post code if you want but I'm still tidying it up. If you know a better more efficient way of doing this I would love to know it. You can post the code and get advice on improving the code. It sounds very much like ...
by FanaticGuru
06 Oct 2020, 11:37
Forum: Ask For Help
Topic: String parsing peeking at the next character.
Replies: 9
Views: 166

Re: String parsing peeking at the next character.

That would take some rethinking on the script and how it functions. I'm copying several lines from Excel into an array of arrays that represent the lines and fields and am using this to fill in a number of forms. It's certainly working the way I have it, I just thought the parse loop was quicker th...
by FanaticGuru
06 Oct 2020, 11:23
Forum: Ask For Help
Topic: save mail attachment to folder
Replies: 4
Views: 123

Re: save mail attachment to folder

I made this code to create a folder with the name of the email subject f6:: Renamef=%Clipboard% ; manualy copy email subject ClipWait, 2 FileCreateDir, F:\2020\%Renamef% Sleep,100 run F:\2020\%Renamef% can this code be combined with yours to be just one command? i use thunderbird email Thanks The c...
by FanaticGuru
05 Oct 2020, 17:42
Forum: Ask For Help
Topic: save mail attachment to folder
Replies: 4
Views: 123

Re: save mail attachment to folder

Hello! With autohotkey the following command can be made? I have an email (ex. abcd) - first, copy email subject - create a folder and rename it with "abcd" and save email atachement in that folder "abcd" Thank you! Here is a start. #F12:: olApp := ComObjActive("Outlook.Application") try olItem := ...
by FanaticGuru
05 Oct 2020, 16:22
Forum: Ask For Help
Topic: store excel array as a variable Topic is solved
Replies: 4
Views: 77

Re: store excel array as a variable Topic is solved

Dear all, I have an excel table with 5 columns (A to E) and 5 rows (1 TO 5) I want to store the output of each individual cell as a variable. I know how to output the array of columns but not each individual cell (see example below) Does anyone know how to do this. for example if I want to store th...

Go to advanced search