AutoHotkey Community

Datapoint

Since you already know VBA, it should be relatively easy for you to use COM. It will be much more reliable that sending mouse clicks.

This example, for starters:
Basic Ahk_L COM Tutorial for Excel

Datapoint

I modified Joe's XL_Format_HAlign so that it will take whatever cell(s) are selected, instead of having to define the range first: ;------------------------------------------------------------- ExcelActions_HAlign(ByRef XL, RG="", h="2"){ Cell_address = % XL.ActiveCell.Address[1,1] Range_address :=...

Datapoint

ComObjActive("Excel.Application").ActiveSheet.Next.Activate ; activate next ComObjActive("Excel.Application").ActiveSheet.Previous.Activate ; activate prev. ComObjActive("Excel.Application").ActiveWorkbook.Worksheets(3).Activate ; activate #3 ComObjActive("Excel.Application").ActiveWorkbook.Workshe...

Datapoint

msoShapeRectangle := 1, xlHAlignCenter := -4108, xlVAlignCenter := -4108 xl := ComObjActive("Excel.application") TxtFrm := xl.ActiveSheet.Shapes.AddShape(msoShapeRectangle, 10, 10, 200, 100).TextFrame TxtFrm.Characters.Text := "This is a rectangle" TxtFrm.HorizontalAlignment := xlHAlignCenter TxtFr...

Datapoint

I didn't test this but I think it should be something like this: /* ActiveWorkbook.SlicerCaches("Slicer_Date.Month3").VisibleSlicerItemsList = _ * Array( _ * "[Date].[Month].&[4]", "[Date].[Month].&[5]") * ActiveWorkbook.SlicerCaches("Slicer_Date.Day_In_Month").VisibleSlicerItemsList _ * = Array( _ ...

Datapoint

Hi AbooMatta, Your script is probably sending keystrokes faster than Excel can handle. If one step takes Excel a bit more time to do but your script keeps sending stuff in the meantime then the script will get out of sync with Excel. Maybe try adding Sleeps between some actions to try to improve the...

Datapoint

Based on the other thread from https://www.autohotkey.com/boards/viewtopic.php?f=76&t=69631 the following should add the 'details' to the match.. it's trivial to just match the previous line. #NoEnv SetBatchLines, -1 nma2 := "nma2" clip := " (Join`r`n zzzzzz xxxxx nma2 X example (not this one) Y exa...

Datapoint

try to add .Application It looks like it may need to be Application.COMAddIns . No. Wrong. objExcel in the posted code contains an application object. objExcel.Application is the same as Application.Application :facepalm: from time to time people do not understand the differences between AHk vs VBA...

Datapoint

White_Whale wrote: ↑
28 Sep 2019, 00:47
I tried
Code: Select all
	tempArray%A_Index%[0] := 1

Shouldn't it be the column number? Like this:

Code: Select all

	tempArray%A_Index%[0] := A_Index

White_Whale wrote: ↑
28 Sep 2019, 00:47
Code: Select all
RegExReplace(myContent, ".+\r\n",, lineCounts)

White_Whale wrote: ↑
28 Sep 2019, 01:13
ah, "lineCounts" should be "columnCounts" but that is not the point here

Did you change the RegEx to count tabs (columns)?

Datapoint

#k:: wb1 := ComObjGet(A_Desktop "\1.xlsx") wb2 := ComObjGet(A_Desktop "\2.xlsx") MsgBox % wb1.ActiveSheet.Range("A1").Text MsgBox % wb2.ActiveSheet.Range("A1").Text last_cell := wb1.Sheets("DE Doc").Range("A:A").SpecialCells(11).row new_cell := wb1.Sheets("DE Doc").Range("A" last_cell+1) new_cell.v...

Datapoint

try

Code: Select all

Instruction := "The category is " Category

https://www.autohotkey.com/docs/Variables.htm#Intro

Code: Select all

MyNumber := 123
MyString := "This is a literal string."
CopyOfVar := Var  ; Unlike its counterpart in the previous section, percent signs are not used with the := operator.

Datapoint

doncole wrote: ↑
05 Jul 2019, 23:40

I found it but looks different than your picture.
Thank you.

I don't see your image.

The only way I can make sense of your comments is that maybe you are using a different theme.

Datapoint

Here, I found it for you:
https://www.autohotkey.com/boards/memberlist.php?mode=viewprofile&u=79083
as I said before, click "Search user’s posts" on that page

Datapoint

Are you using a weird browser?
Are you using something that blocks content from being shown on webpages?
It's literally at the top of this page.

Datapoint

: Untitled.png (228.54 KiB) Viewed 2486 times

Datapoint

doncole wrote: ↑
05 Jul 2019, 22:15
Top right of what page?

This page or any other.

Datapoint

Go to your profile (top right):

: User Profile; Untitled.png (38.77 KiB) Viewed 2528 times

then click "Search user’s posts"

Datapoint

Try it like this. You need to save A_LoopFileFullPath because it will be blank outside the loop. !q:: inputbox, userinput, Enter Full Project ID, , ,300 ,100 ; If the user pressed cancel or the string is too short if (ErrorLevel || StrLen(userinput) = 0) MsgBox, No file specified ;sleep, 500 FoundFi...

Datapoint

edited my previous post to add the `a
https://regex101.com/r/618UAe/1

Datapoint

"`am)^\s*;.*(?:\R|$)"

Search found 76 matches

Re: Loop through Excel list (with hyperlinks)

Re: Excel: Find address of selection using COM Topic is solved

Re: Excel-AHK

Re: Excel: insert rectangle

Re: Slicer excel VBA to AHK

Re: Hotkey in Excel stops before finishing

Re: parsing above with regexmatch instead of below Topic is solved

Re: Why Excel Addins is Wrong?

Re: Array of Arrays for MS Excel VBA txt file reading (some different txt format) Topic is solved

Re: Handle multiple open Excel files with ComObj Topic is solved

Re: Quotation Marks and Variables

Re: How to find my last post

Re: How to find my last post

Re: How to find my last post

Re: How to find my last post

Re: How to find my last post

Re: How to find my last post

Re: Finding Excel File. Loop, Files Topic is solved

Re: Regex to remove comment lines Topic is solved

Re: Regex to remove comment lines Topic is solved