Search found 283 matches

by Tigerlily
01 Jul 2019, 14:16
Forum: Offtopic
Topic: TIOBE Index Topic is solved
Replies: 15
Views: 972

Re: TIOBE Index Topic is solved

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...
by Tigerlily
01 Jul 2019, 00:41
Forum: AutoHotkey v2 Development
Topic: Will AutoHotkey v2 Syntax Be More Confusing For Newbies?
Replies: 72
Views: 3759

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

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,...
by Tigerlily
13 May 2019, 00:27
Forum: Ask For Help
Topic: Highlighted Text to Excel or Word Topic is solved
Replies: 3
Views: 206

Re: Highlighted Text to Excel or Word Topic is solved

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...
by Tigerlily
11 May 2019, 01:09
Forum: Ask For Help
Topic: Highlighted Text to Excel or Word Topic is solved
Replies: 3
Views: 206

Re: Highlighted Text to Excel or Word Topic is solved

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 ...
by Tigerlily
22 Apr 2019, 05:56
Forum: Ask For Help
Topic: Get value of current cell in Excel Topic is solved
Replies: 1
Views: 105

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

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.
:roll:

Code: Select all

Xl := ComObjActive("Excel.Application")
MsgBox % Xl.ActiveCell.Value
by Tigerlily
22 Apr 2019, 03:35
Forum: Ask For Help
Topic: Attaching Excel Sheet
Replies: 24
Views: 893

Re: Attaching Excel Sheet

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...
by Tigerlily
18 Apr 2019, 20:21
Forum: Ask For Help
Topic: How to make clipboard paste support for file/folder
Replies: 19
Views: 844

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

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...
by Tigerlily
18 Apr 2019, 20:12
Forum: Ask For Help
Topic: Alternative for contains when using arrays?
Replies: 5
Views: 308

Re: Alternative for contains when using arrays?

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 ...
by Tigerlily
18 Apr 2019, 11:29
Forum: Ask For Help
Topic: Run function after windows log on
Replies: 2
Views: 134

Re: Run function after windows log on

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...
by Tigerlily
18 Apr 2019, 05:11
Forum: Ask For Help
Topic: How to make clipboard paste support for file/folder
Replies: 19
Views: 844

Re:

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...
by Tigerlily
18 Apr 2019, 04:40
Forum: Ask For Help
Topic: Counting how many times item is in string Topic is solved
Replies: 9
Views: 363

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

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...
by Tigerlily
18 Apr 2019, 03:01
Forum: Ask For Help
Topic: Get the name of a screen Topic is solved
Replies: 8
Views: 545

Re: Get the name of a screen Topic is solved

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. ...
by Tigerlily
18 Apr 2019, 01:24
Forum: Tips and Tricks
Topic: list of every command/function/variable from across all versions
Replies: 24
Views: 17836

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

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 ...
by Tigerlily
18 Apr 2019, 01:22
Forum: Tips and Tricks
Topic: list of every command/function/variable from across all versions
Replies: 24
Views: 17836

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

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...
by Tigerlily
18 Apr 2019, 01:01
Forum: Ask For Help
Topic: Excel pasting data Topic is solved
Replies: 2
Views: 160

Re: Excel pasting data Topic is solved

Oh looks like you found your solution before i posted :p
by Tigerlily
18 Apr 2019, 01:00
Forum: Ask For Help
Topic: Excel pasting data Topic is solved
Replies: 2
Views: 160

Re: Excel pasting data Topic is solved

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 ...
by Tigerlily
17 Apr 2019, 13:26
Forum: Ask For Help
Topic: Highlight a Folder (by Name or Path) in the active Windows 10 Explorer window Topic is solved
Replies: 8
Views: 371

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

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

:arrow: Explorer docs for more info
by Tigerlily
17 Apr 2019, 06:36
Forum: Ask For Help
Topic: Attaching Excel Sheet
Replies: 24
Views: 893

Re: Attaching Excel Sheet

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...
by Tigerlily
15 Apr 2019, 23:49
Forum: Ask For Help
Topic: misspelled words with windows 10
Replies: 4
Views: 296

Re: misspelled words with windows 10

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...
by Tigerlily
15 Apr 2019, 23:40
Forum: Ask For Help
Topic: Issues working with two Excel files
Replies: 8
Views: 463

Re: Issues working with two Excel files

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 ...

Go to advanced search