Search found 9 matches
- 08 Jun 2023, 03:12
- Forum: SciTE4AutoHotkey
- Topic: Help with SciTE4AutoHotkey install please.
- Replies: 2
- Views: 763
Re: Help with SciTE4AutoHotkey install please.
The last screenshot is from selecting SciTE4AutoHotkey Diagnostic Utility from the editor.
- 07 Jun 2023, 12:55
- Forum: SciTE4AutoHotkey
- Topic: Help with SciTE4AutoHotkey install please.
- Replies: 2
- Views: 763
Help with SciTE4AutoHotkey install please.
I had previously installed AHK V2 (lot of effort to get admin to install it). In order to install SciTE4AutoHotkey I uninstalled AHK and re-installed it to the following location (no admin needed): C:\Users\xxx\AppData\Local\Programs Then downloaded portable SciTE4AutoHotkey and copied the SciTE dir...
- 05 Jun 2023, 11:43
- Forum: Ask for Help (v2)
- Topic: Hotstring paste to Excel cell
- Replies: 17
- Views: 1627
Re: Hotstring paste to Excel cell
Very useful info on COM and Editors - Many thanks Datapoint!
- 31 May 2023, 14:17
- Forum: Ask for Help (v2)
- Topic: Hotstring paste to Excel cell
- Replies: 17
- Views: 1627
Re: Hotstring paste to Excel cell
Thanks for your comments on COM, I’ve managed to get both versions working. Is there any info on how to use COM related functions (not just Excel) as so far, it’s been trial and error and sifting through other code to pick up things. Currently using Notepad - Is there an editor that does not need in...
- 30 May 2023, 16:29
- Forum: Ask for Help (v2)
- Topic: Hotstring paste to Excel cell
- Replies: 17
- Views: 1627
Re: Hotstring paste to Excel cell
Thank you for all the responses. Adding a delay does indeed work but not sure exactly why. Its been great learning experience and this will help me create more complex excel AHKs. For this particular case, I'll be using Datapoint's solution using Send "^v" as this append to the cell content which is...
- 29 May 2023, 06:29
- Forum: Ask for Help (v2)
- Topic: Hotstring paste to Excel cell
- Replies: 17
- Views: 1627
Re: Hotstring paste to Excel cell
The revised script: #Requires AutoHotkey v2.0 #SingleInstance Force ;Only allow one instance and with Force replaces old instance. excelPaste1(str) { Send '{Esc}' ComObjActive('Excel.Application').ActiveCell := str } #HotIf WinActive('ahk_exe EXCEL.exe') ::#sn1:: { clipsaved := A_Clipboard loop { cl...
- 28 May 2023, 14:26
- Forum: Ask for Help (v2)
- Topic: Hotstring paste to Excel cell
- Replies: 17
- Views: 1627
Re: Hotstring paste to Excel cell
Thanks for your continued support. boiler – Using work laptop with Microsoft® Excel® for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20660) 32-bit, fully licenced and all patched applied automatically. mikeyww – Slight improvement after implementing your changes in that when I reload the script...
- 27 May 2023, 06:57
- Forum: Ask for Help (v2)
- Topic: Hotstring paste to Excel cell
- Replies: 17
- Views: 1627
Re: Hotstring paste to Excel cell
Thank you all for the quick fantastic response, with different solutions. I tried them all to increase my learning and had mixed results. Datapoint – Both worked and easy to implement – Thanks. Mikeyww & flyingDman – Tried these but did not work for me, for both solutions, I got the following error ...
- 26 May 2023, 14:55
- Forum: Ask for Help (v2)
- Topic: Hotstring paste to Excel cell
- Replies: 17
- Views: 1627
Hotstring paste to Excel cell
Hi all. I’m new to AHK and need some help creating a hotstring for use with excel. I would like to paste content I have in a variable (clipboard text I re-formatted). Using MsgBox, I can see the text is exactly as I want it but when I use my hotstring in a cell, it spills to rows below (there are mu...