AutoHotkey Community

Tigerlily

I searched earlier today and got 5,000+ results. +"autohotkey programming" About 5,190 results (0.24 seconds) I also got confirmation that AutoHotkey will be added to the list of programming languages as of the next publications. The first one is to be expected in the beginning of May. Cheers. Wooh...

Tigerlily

Will AutoHotkey v2 Syntax Be More Confusing For Newbies? No. I started using AutoHotkey less than a year ago. I learned a considerable amount in a very short time period, with absolutely zero prior exposure or experience to programming. Was AutoHotkey v1 easy to learn? No. I had to put in the time,...

Tigerlily

Thank you so much! No prob. You will find that this script may not work on the spreadsheet you are intending it to if you have more than 1 instance of EXCEL.EXE running. Since you are new, note that the top 3 lines of code are not required, but I typically add them to all my scripts to increase per...

Tigerlily

Hi guys, New here to AHK. Basically I was wondering if there would be a way to take highlights text and copy that into an excel spreadsheet or word doc of sorts. I would want it to be able to do it over and over again so it would be great if it would go to the next row or the next line in the word ...

Tigerlily

Indhu wrote: ↑
22 Apr 2019, 04:32
Hi,
In Excel sheet, if I click the cell A3. How shall I get the current value of the cell(cell which is enabled green border) via autohotkey.

Code: Select all

Xl := ComObjActive("Excel.Application")
MsgBox % Xl.ActiveCell.Value

Tigerlily

This is my script. a:: Path := A_Desktop "\Data\Input.xlsx" XL := ComObjCreate("Excel.Application") XL.Workbooks.Open(Path) XL.Visible := True Still the same error with a new notepad file. Does this work? Path := A_Desktop "\Data\Input.xlsx" Run, % Path Does this work? excel:=ComObjCreate("Excel.Ap...

Tigerlily

How to make clipboard paste support for file/folder I would like to do.. clipboard:="D:\myfile" I thought, when i press ctrl+v, it will paste the file to my location dir.,,But not. How Can i ?? Help pls.. Edit : Topic subject added ~ gregster I could be wrong but I think everyone is guessing at thi...

Tigerlily

If I use stringsplit then I have the option to use contains like this: nos = 1 stringsplit, mylist, mylist, `n if mylist%nos% contains item1,item2,item3 ; no error But stringsplit is depreciated. However, if I use strsplit in the same way I get an error: nos = 1 mylist := strsplit(mylist, "`n") if ...

Tigerlily

Is there a way to run a function each time a user logs on to Windows 10? More Context: Target audience are work computers. When not in use, users are logged out. Each time a user logs back in, they must take steps to restart various programs and modify their configuration. Starting those programs a...

Tigerlily

How to make clipboard paste support for file/folder I would like to do.. clipboard:="D:\myfile" I thought, when i press ctrl+v, it will paste the file to my location dir.,,But not. How Can i ?? Help pls.. Try this: FileRead, Clipboard, D:\myfile.txt Oh nvm, looks like you are looking to do somethin...

Tigerlily

There probably is a better way to do this, but this works :) assuming each number combo is 4 digits numberCombo := "2122,3285,6525,2122,5485,6525" For key in (sku := StrSplit(numberCombo, ",")) StrReplace(numberCombo, sku[A_Index],, Occurances) , results .= Occurances . sku[A_Index] "`n" Sort, resu...

Tigerlily

I just bought a separate pc for receiving weather satellites and weather information. I use AHK for automating some processes. One program (Wxtoimg-Pro) has a problem: the Auto Record button switches off after receiving a satellite. The program is not maintained anymore so I cannot ask the author. ...

Tigerlily

Excel MSDN docs COM Vocabulary List (with Enumerations/Constants) [PART 2/2, W-Z] - Tab-delimited: Walls object Methods ClearFormats Walls object Methods Paste Walls object Methods Select Walls object Properties Application Walls object Properties Creator Walls object Properties Format Walls object ...

Tigerlily

Hi jeeswg, Great stuff. I would love to see the COM vocabulary. Maybe with links to specific help. Maybe as a prelude to a COM CHM/HTML file(s). Getting just the basic terms will be a job. Thanks Here's a start - Excel file attached below with all associated links out to most up-to-date MSDN docs p...

Tigerlily

Oh looks like you found your solution before i posted :p

Tigerlily

Hi, I got an issue. Somethimes, when you copy paste a table from a source to a excel, it keeps the column order and paste the data in separate columns. the spearator in the clipboard is ; . When you send a info into Excel via FileAppend, using ; separator, it also separates the columns. But when I ...

Tigerlily

jwinfl wrote: ↑
17 Apr 2019, 11:21
How do I Highlight an existing Folder (using it's Name or Path) in the active Windows 10 Explorer window?

try this:

Code: Select all

filepath := "C:\Users\User\Desktop\YourFile.txt"
Run, % "explorer /select, " filepath

Explorer docs for more info

Tigerlily

Hello people, I'm trying to attach an excel sheet, with my script, so that I can have my excel sheet data into clipboard, from which I can use those in a seperate application. I started off like in the following code, but I keep on getting this error "The following variable name contains an illegal...

Tigerlily

When I use the shortcut keys in AHK the shortcuts are misspelled. Just updated to windows 10 from windows 8. Any ideas? Likely are referring to Hotstrings. I would try using SetKeyDelay to slow down the send of each character. Try putting SetKeyDelay, 100, 50 at the top of your script and see if th...

Tigerlily

What is the COM table and how would one access it? In short it is a dating site for applications that Windows runs to help programs hookup and create lots of little subroutines. :lol: Thanks FG - this is great. I've been working on a script that manages this issue by putting all the workbooks that ...

Search found 283 matches

Re: TIOBE Index Topic is solved

Re: Will AutoHotkey v2 Syntax Be More Confusing For Newbies?

Re: Highlighted Text to Excel or Word Topic is solved

Re: Highlighted Text to Excel or Word Topic is solved

Re: Get value of current cell in Excel Topic is solved

Re: Attaching Excel Sheet

Re: How to make clipboard paste support for file/folder

Re: Alternative for contains when using arrays?

Re: Run function after windows log on

Re:

Re: Counting how many times item is in string Topic is solved

Re: Get the name of a screen Topic is solved

Re: list of every command/function/variable from across all versions

Re: list of every command/function/variable from across all versions

Re: Excel pasting data Topic is solved

Re: Excel pasting data Topic is solved

Re: Highlight a Folder (by Name or Path) in the active Windows 10 Explorer window Topic is solved

Re: Attaching Excel Sheet

Re: misspelled words with windows 10 Topic is solved

Re: Issues working with two Excel files