Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 89
» Latest member: furyvwilder3
» Forum threads: 56
» Forum posts: 118

Full Statistics

Online Users
There are currently 31 online users.
» 0 Member(s) | 30 Guest(s)
Google

Latest Threads
Error with download file
Forum: The Enterpad corner
Last Post: foscmgt
03-25-2020, 03:52 PM
» Replies: 9
» Views: 372
small problems
Forum: The Enterpad corner
Last Post: denilama
03-14-2020, 07:28 PM
» Replies: 1
» Views: 112
Keyboard Shortcut - Find ...
Forum: Keyboard shortcuts with AutoHotkey code
Last Post: denilama
11-01-2019, 11:48 AM
» Replies: 1
» Views: 514
Keyboard Shortcut - Find ...
Forum: Keyboard shortcuts with AutoHotkey code
Last Post: denilama
11-01-2019, 11:47 AM
» Replies: 1
» Views: 527
Keyboard Shortcut - Launc...
Forum: Keyboard shortcuts with AutoHotkey code
Last Post: denilama
10-18-2019, 12:43 PM
» Replies: 1
» Views: 645
Pay by mastercard
Forum: The Enterpad corner
Last Post: denilama
08-06-2019, 12:57 PM
» Replies: 1
» Views: 3,645
Keyboard Shortcut - Launc...
Forum: Keyboard shortcuts with AutoHotkey code
Last Post: Ma18
06-14-2019, 12:51 AM
» Replies: 1
» Views: 2,601
How to create a keyboard ...
Forum: Keyboard shortcuts with AutoHotkey code
Last Post: denilama
05-20-2019, 08:19 AM
» Replies: 2
» Views: 3,841
ShortKeeper in Egypt! (re...
Forum: ShortKeeper suggestions and feedback
Last Post: iamhja
03-30-2019, 12:59 PM
» Replies: 1
» Views: 2,811
Introduction
Forum: Need help with ShortKeeper?
Last Post: stefini3
03-14-2019, 07:54 AM
» Replies: 4
» Views: 3,498

 
  Mouse click error
Posted by: denilama - 05-11-2018, 10:33 AM - Forum: Need help with ShortKeeper? - Replies (1)

Note: This post is taken from another forum where I provide ShortKeeper support.

Quote:Mouse click (Error with shortcut 9, line 3. This line does not contain a recognized action. Specifically: 300, 400 Failed attempt to start AutoHotkey.)

"Example of Param" (at the bottom of the center column) should have specified "Click, 300, 400" instead of just "300, 400". The help content has been updated (ShortKeeper v1.0.1.9). Don’t miss the three-dot helper button (to the right of Param) to get the screen coordinates.

Thank you for your feedback.

Print this item

  Extra Clipboard
Posted by: denilama - 05-11-2018, 10:25 AM - Forum: Need help with ShortKeeper? - No Replies

Note: This post is taken from another forum where I provide ShortKeeper support.

Quote:Extra Clipboard, He does not write the letter i.

I imagine that you are using "Copy text to extra clipboard" or "Paste text from extra clipboard" to insert (instead of copy/paste) text. In the Param field for this command, you need to specify a clipboard number (e.g. 1, 2, 3, etc.). It should not contain the text you want to copy or paste. We will try to improve the help content. Please let me know if you still don’t understand how to use the clipboard commands. They are really useful.

Print this item

  Review of the Enterpad by Ryan Wells
Posted by: denilama - 04-27-2018, 01:22 PM - Forum: The Enterpad corner - No Replies

Ryan Wells writes:

I’m doing something a little different here today. Today I’m going to give you a product review on a neat little device the great guys at Cedeq sent my way. The product is called the Enterpad VBA and it’s a slight variant on the more popular AutoHotKey Enterpad.

The Enterpad VBA is a physical product that lets you run macros in Excel and Word with the push of a button. It really can speed up your spreadsheet work!

See complete article (with pictures) at: https://wellsr.com/vba/2018/review/cedeq...ba-review/

Print this item

Lightbulb Keyboard Shortcut - Paste Unformatted Text in MS Word
Posted by: denilama - 04-25-2018, 06:46 PM - Forum: Keyboard shortcuts with AutoHotkey code - No Replies

Copying and pasting text from a web page into an MS Word document can be more trouble than it’s worth. We’ve all experienced it at least once. Changing the font, changing its size, changing its color, and changing other formatting are the usual steps involved. What if you could paste text with a macro that gets rid of all that unnecessary formatting? The ‘Paste Special’ command in MS Word has an option for this, but it takes several steps. With this little script, you can do it in one.

Need help creating a keyboard shortcut with ShortKeeper using the following AutoHotkey code? This 5-minute tutorial will help!

Critical
if WinActive("ahk_class OpusApp")
{
  ControlGet, hwnd, hwnd, , _WwG1, A
  if DllCall("oleacc\AccessibleObjectFromWindow", "Ptr", hwnd, "UInt", 0xFFFFFFF0, "Ptr", -VarSetCapacity(IID,16)+NumPut(0x46000000000000C0, NumPut(132096, IID, "Int64"), "Int64"), "Ptr*", pacc) = 0
    WordApp := ComObject(9, pacc, 1).Application
  WordApp.Selection.PasteSpecial(,,,,2)
}
else
  MsgBox 0x40040, ShortKeeper, There is no Word document window active.

The script will paste the text if the Word document is the active window and is not busy (e.g. selecting a command).

This script is optimized to be used with ShortKeeper. As such, there is no exception handling, no “Return” at the end, and variable(s) don’t need to be cleared. ShortKeeper does all of this automatically. Just copy/paste the code in the PARAM field in ShortKeeper, set your hotkey, save, and you’re ready to use your new keyboard shortcut.

Print this item

Lightbulb Keyboard Shortcut - Protect/Unprotect the Current Worksheet in Excel
Posted by: denilama - 04-20-2018, 08:34 AM - Forum: Keyboard shortcuts with AutoHotkey code - No Replies

It is a good habit to protect a worksheet against inadvertent changes when analyzing its data. The following Autohotkey code (script) lets you create a keyboard shortcut that will quickly protect an unprotected worksheet. The same keyboard shortcut will unprotect a protected worksheet. This shortcut works with any worksheet; no Excel add-in required.

Need help creating a keyboard shortcut with ShortKeeper using the following AutoHotkey code? This 5-minute tutorial will help!

Critical
if WinActive("ahk_class XLMAIN")
{
  ControlGet, hwnd, hwnd, , Excel71, A
  if DllCall("oleacc\AccessibleObjectFromWindow", "Ptr", hwnd, "UInt", 0xFFFFFFF0, "Ptr", -VarSetCapacity(IID,16)+NumPut(0x46000000000000C0, NumPut(132096, IID, "Int64"), "Int64"), "Ptr*", pacc) = 0
    ExcelSheet := ComObject(9, pacc, 1).ActiveSheet
  if (ExcelSheet.ProtectContents)
  {
    ExcelSheet.Unprotect
    MsgBox ,,,% "Worksheet Unprotected.", 1
  }
  else
  {
    ExcelSheet.Protect
    MsgBox ,,,% "Worksheet Protected.", 1
  }
}
else
  MsgBox 0x40040, ShortKeeper, There is no Excel worksheet window active.

The setting will be applied if the Excel worksheet is the active window and is not busy (e.g. editing, selecting a command).

The number “1” at lines #10 and #15 sets a 1-second duration for a dialog box to appear indicating the change process. For the dialog box to remain longer, simply adjust the value (e.g., 2, 3, etc.).

This script is optimized to be used with ShortKeeper. As such, there is no exception handling, no “Return” at the end, and variable(s) don’t need to be cleared. ShortKeeper does all of this automatically. Just copy/paste the code in the PARAM field in ShortKeeper, set your hotkey, save, and you’re ready to use your new keyboard shortcut.

Print this item

  ShortKeeper vs Autohotkey
Posted by: Oli_B - 04-17-2018, 09:37 AM - Forum: ShortKeeper suggestions and feedback - Replies (1)

Comparing these two is like comparing a car and a tire. You need both and they complement each other. In this case, Shortkeeper is the vehicle that uses AutoHotKey tires...and trust me it is a Cadillac! 

For those who don't know, AutoHotKey (AHK) is an open-source scripting language for Windows which consist of tasks automation like auto-clicking, macros, etc. ShortKeeper is a platform that integrates AHK and is a lot less difficult to use if you want to manage hotkeys. Let's be honest. Do you have enough time to learn a programmation language? The time you will need to learn it will be longer than the time it will make you save!

So to make a long story short, ShortKeeper is 'AutoHotKey for dummies'. You select which category of macro you want to have and you write it down plain and simple. Shortkeeper converts it into AHK language and you have nothing else to do.

And because you don’t need to learn AHK language to set your macros, on the long run, it is an advantage to use ShortKeeper because six months from now or twelve months from now you will be able to modify or add new macros compare to AutoHotKey where you would have forget everything you learned back then.

For those of you who already know how AHK works, you also have a category in ShortKeeper that allows you to put your AHK skills on display! Well don't waste any time and go download ShortKeeper here at https://cedeq.com/shortkeeper/en and get in the driver seat!

Print this item

Lightbulb Keyboard Shortcut - Highlight the Current Row in Excel
Posted by: denilama - 04-12-2018, 02:45 PM - Forum: Keyboard shortcuts with AutoHotkey code - No Replies

A keyboard shortcut to quickly highlight a row in Excel (change its background color to yellow, for instance) will certainly be appreciated by someone having to analyze plenty of data. The following AutoHotkey script allows you to do exactly this. Also, if the row is already highlighted, the same keyboard shortcut will simply remove the highlight. This shortcut works with any worksheet; no Excel add-in required.

Need help creating a keyboard shortcut with ShortKeeper using the following AutoHotkey code? This 5-minute tutorial will help!

Critical
HCIndex := 6
if WinActive("ahk_class XLMAIN")
{
  ControlGet, hwnd, hwnd, , Excel71, A
  if DllCall("oleacc\AccessibleObjectFromWindow", "Ptr", hwnd, "UInt", 0xFFFFFFF0, "Ptr", -VarSetCapacity(IID,16)+NumPut(0x46000000000000C0, NumPut(132096, IID, "Int64"), "Int64"), "Ptr*", pacc) = 0
    ExcelApp := ComObject(9, pacc, 1).Application
  Row := ExcelApp.Rows(ExcelApp.Selection.Row).Interior
  if Row.ColorIndex = HCIndex
    Row.ColorIndex := 0
  else
    Row.ColorIndex := HCIndex
}
else
  MsgBox 0x40040, ShortKeeper, There is no Excel worksheet window active.

The script will highlight the row (or remove the highlight) if the Excel worksheet is the active window and is not busy (e.g. editing, selecting a command).

The number 6 in line #2 sets the color of the highlight to yellow. A decimal number from 0 to 56 allows for different color options. The following list includes some common color choices:
  • Auto, 0
  • Black, 1
  • White, 2
  • Red, 3
  • Bright Green, 4
  • Blue, 5
  • Yellow, 6
  • Pink, 7
  • Turquoise, 8
  • Dark Red, 9
  • Green, 10
  • Dark Blue, 11
  • Dark Yellow, 12
  • Violet, 13
  • Teal, 14
  • Grey 25, 15
  • Grey 50, 16

This script is optimized to be used with ShortKeeper. As such, there is no exception handling, no “Return” at the end, and variable(s) don’t need to be cleared. ShortKeeper does all of this automatically. Just copy/paste the code in the PARAM field in ShortKeeper, set your hotkey, save, and you’re ready to use your new keyboard shortcut.

Print this item

Lightbulb Keyboard Shortcut - Auto Login to a TMX Money Account
Posted by: denilama - 04-05-2018, 03:42 PM - Forum: Keyboard shortcuts with AutoHotkey code - No Replies

Stock trading requires you to be fast. If you have an account on TMX Money (https://web.tmxmoney.com) and want a keyboard shortcut that will automatically log you in, the following AutoHotkey script will help. The shortcut will open TMX Money in Internet Explorer, enter your username and password in the appropriate fields, and bring you to your TMX Money home page.

Need help creating a keyboard shortcut with ShortKeeper using the following AutoHotkey code? This 5-minute tutorial will help!

Username := "YourUsername"
Password := "YourPassword"
URL := "https://web.tmxmoney.com/account/login-register.php"
wb := ComObjCreate("InternetExplorer.Application")
wb.Visible := True
wb.Navigate(URL)
TimeOut := 20
While wb.readyState != 4 || wb.document.readyState != "complete" || wb.busy
{
 Sleep, 1000
 TimeOut := TimeOut - 1
 if (TimeOut = 0)
   return
}
Sleep, 1000
wb.document.getElementById("qm-username").value := Username
wb.document.getElementById("qm-password").value := Password
wb.document.getElementsByClassName("qmod-account-loginButton")[0].Click()

At lines #1 and #2, “YourUsername” and “YourPassword” must be replaced with the actual user name and password (do not remove quotation marks).

At line #7, a timeout delay of 20 seconds is set in case the script becomes unresponsive (e.g. due to a slow Internet connection) in attempting to load the TMX Money login page. If the timeout expires, the script will simply terminate without inserting the username and password. The timeout delay can be changed if needed.

At line #15, a 1000 milliseconds pause is inserted after the TMX Money login page is loaded and before inserting the username and password. You might have to lengthen the pause for a slow computer.

This script will also work if you are already logged into TMX Money. It will start Internet Explorer even if this is not your default browser. The script was tested with Windows 7 and 10.

If TMX Money changes the way its web page works, this script might stop working. If you experience any problems, please let me know with a post on this thread. You can subscribe to the thread to be notified of any updates.

Use a password stored in an external encrypted file

Someone with access to your ShortKeeper application might be able to see your TMX Money password, which some users may find insecure. This section explains how to use a password stored in a separate file that is protected with a master password.

To begin, replace line #2 of the script above with the following two lines:
PasswordName := "tmxmoney"
ExternalFileName := "T:\MyData.ini"
At line #2, "T:\MyData.ini" must refer to the path and filename of the external password file (do not remove quotation marks).

Now, to get the password from the external file, the following line of code must be inserted between line #16 and line #17 of the script above:
IniRead, Password, % ExternalFileName, % "Passwords", % PasswordName

The following line inserted between lines #17 and #18 will make sure the password in the computer memory is cleared as soon as possible:
Password :=

Then you will have to create an external file (a simple text file will do) with an ".ini" extension with content like this:

[Passwords]
tmxmoney=YourPassword
AnotherPasswordName=AnotherPassword

You can add all of your other passwords to the same file.

If the external file cannot be read (e.g. if it is encrypted), the inserted password will be "ERROR" instead of the actual password.

There are several ways to encrypt/decrypt the external file. If you are using TrueCrypt, you could insert the following code between lines #3 and #4 above. This will prompt you to enter the master password if the file is not already decrypted:
if (!FileExist(ExternalFileName))
{
TrueCryptPath := "C:\Program Files (x86)\TrueCrypt\TrueCrypt.exe"
ContainerPath := "U:\TrueCryptContainer.tc"
RunWait % TrueCryptPath . " /q /lt /v " . ContainerPath
}
At line #3, "C:\Program Files (x86)\TrueCrypt\TrueCrypt.exe" must refer to the path of TrueCrypt.exe (do not remove quotation marks).

At line #4, "U:\TrueCryptContainer.tc" must refer to the path of the TrueCrypt file container (do not remove quotation marks).[/i]

Print this item

  Enterpad availability & order
Posted by: Melb12 - 04-04-2018, 12:30 PM - Forum: The Enterpad corner - Replies (1)

Greetings from Melbourne, Aust!

Could you please advise on price + shipping costs & turnaround time to Aust.

We have purchased a few before from you but lost my contact details.

Print this item

  How to put a delay
Posted by: Philippe27 - 03-26-2018, 06:22 PM - Forum: Need help with ShortKeeper? - Replies (5)

One of my shortcut is to enter my username then my password and then press enter all in one. The problem is the enter is too quick and sometimes my password is not completed before the enter occures. It leads to an error and I have to do it all over again. Is there a way to have a delay between the end of the password and the enter?

Print this item