Search found 9 matches

by B1T
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.
by B1T
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...
by B1T
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!
by B1T
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...
by B1T
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...
by B1T
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...
by B1T
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...
by B1T
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 ...
by B1T
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...

Go to advanced search