Search found 67 matches

by Datapoint
07 Sep 2019, 16:52
Forum: Ask For Help
Topic: Handle multiple open Excel files with ComObj Topic is solved
Replies: 16
Views: 841

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

#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...
by Datapoint
10 Jul 2019, 23:21
Forum: Ask For Help
Topic: Quotation Marks and Variables
Replies: 4
Views: 241

Re: Quotation Marks and Variables

try

Code: Select all

Instruction := "The category is " Category
:arrow: 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.
by Datapoint
06 Jul 2019, 02:31
Forum: Ask For Help
Topic: How to find my last post Topic is solved
Replies: 13
Views: 561

Re: How to find my last post Topic is solved

doncole wrote:
05 Jul 2019, 23:40
Image
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.
by Datapoint
05 Jul 2019, 23:27
Forum: Ask For Help
Topic: How to find my last post Topic is solved
Replies: 13
Views: 561

Re: How to find my last post Topic is solved

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
by Datapoint
05 Jul 2019, 23:04
Forum: Ask For Help
Topic: How to find my last post Topic is solved
Replies: 13
Views: 561

Re: How to find my last post Topic is solved

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.
by Datapoint
05 Jul 2019, 22:42
Forum: Ask For Help
Topic: How to find my last post Topic is solved
Replies: 13
Views: 561

Re: How to find my last post Topic is solved

Untitled.png
Untitled.png (228.54 KiB) Viewed 514 times
by Datapoint
05 Jul 2019, 22:26
Forum: Ask For Help
Topic: How to find my last post Topic is solved
Replies: 13
Views: 561

Re: How to find my last post Topic is solved

doncole wrote:
05 Jul 2019, 22:15
Top right of what page?
This page or any other. ;)
by Datapoint
05 Jul 2019, 20:48
Forum: Ask For Help
Topic: How to find my last post Topic is solved
Replies: 13
Views: 561

Re: How to find my last post Topic is solved

Go to your profile (top right):
Untitled.png
User Profile
Untitled.png (38.77 KiB) Viewed 556 times

then click "Search user’s posts"
by Datapoint
05 Jul 2019, 19:55
Forum: Ask For Help
Topic: Finding Excel File. Loop, Files Topic is solved
Replies: 14
Views: 849

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

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...
by Datapoint
01 Jul 2019, 10:48
Forum: Ask For Help
Topic: Regex to remove comment lines Topic is solved
Replies: 6
Views: 392

Re: Regex to remove comment lines Topic is solved

"`am)^\s*;.*(?:\R|$)"
by Datapoint
30 Jun 2019, 22:43
Forum: Ask For Help
Topic: Read Excel Line, Then Move to Next Row w/ Changing Variables
Replies: 12
Views: 767

Re: Read Excel Line, Then Move to Next Row w/ Changing Variables

The one thing that puzzles me is, why we would need to make them visible (I presume stating "Xl.Visible := True" ?) . Unnecessary and often unwanted in my view. Yeah, code posted in answers in the Ask For Help forums should be assumed to be part of a larger script and the suggestions should be narr...
by Datapoint
30 Jun 2019, 02:27
Forum: Ask For Help
Topic: Read Excel Line, Then Move to Next Row w/ Changing Variables
Replies: 12
Views: 767

Re: Read Excel Line, Then Move to Next Row w/ Changing Variables

Both of you: 1) create com objects 2) don't make them visible 3) don't close them 4) don't clear global com vars.
by Datapoint
30 Jun 2019, 02:12
Forum: Ask For Help
Topic: Macro is saved as a notepad file, how can I change it to a script so I can run it?
Replies: 1
Views: 156

Re: Macro is saved as a notepad file, how can I change it to a script so I can run it?

If the file name ends in .txt then change it to .ahk.
If you can't see either .txt or .ahk at the end of the file name then google "show file extensions" to learn how to show file extensions in Windows.
by Datapoint
28 Jun 2019, 21:02
Forum: Ask For Help
Topic: Finding Excel File. Loop, Files Topic is solved
Replies: 14
Views: 849

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

The final product should look similar to this: Loop, Files, % "I:\My Drive\Webcam\Webcam - Projects\" SubStr(userinput, 1, 4) "\" SubStr(userinput, 1, 15) "*" "\"SubStr(userinput, 1, 15) "*.xlsx" , FD ; eblanc wrote: ; "I:\My Drive\Webcam\Webcam - Projects\TX68\TX68 - 58777 - Sat Inc - Lirna Retail...
by Datapoint
08 Jun 2019, 00:30
Forum: Ask For Help
Topic: New to Using Libraries, Not Understanding How Vista Audio Control Functions works
Replies: 4
Views: 209

Re: New to Using Libraries, Not Understanding How Vista Audio Control Functions works

Thanks for the reply. I tried what you put Device := VA_GetDevice("playback") MsgBox % Device DeviceName := VA_GetDeviceName(Device) MsgBox % DeviceName and it works giving me the correct device name on the second msgbox. On the first one though, what does that number mean, if it stayed the same ev...
by Datapoint
07 Jun 2019, 23:39
Forum: Ask For Help
Topic: New to Using Libraries, Not Understanding How Vista Audio Control Functions works
Replies: 4
Views: 209

Re: New to Using Libraries, Not Understanding How Vista Audio Control Functions works

Hi No clue what: CLSID_MMDeviceEnumerator := "{BCDE0395-E52F-467C-8E3D-C4579291692E}" , IID_IMMDeviceEnumerator := "{A95664D2-9614-4F35-A746-DE8DB63617E6}" means, i'm guessing the numbers are addresses in Windows memory? Not memory addresses... You can think of them as unique ID numbers (stored in t...
by Datapoint
31 May 2019, 13:29
Forum: Ask For Help
Topic: Not able to create Outlook Mail Item
Replies: 3
Views: 175

Re: Not able to create Outlook Mail Item

Am I to believe that I need to use GetNameSpace to access folders and emails within my account? Or, if I already have Outlook open, I can continue to manipulate it with ComObjActive("Outlook.Application")? Application and NameSpace; you don't just use one or the other. If you want to access a membe...
by Datapoint
15 May 2019, 19:51
Forum: Ask For Help
Topic: Coloring the Excel Cell Topic is solved
Replies: 28
Views: 1510

Re: Coloring the Excel Cell Topic is solved

hasantr wrote:So it worked great. Thank you all. :)
Cool script. Glad to hear it works.
BTW the PixelGetColor default is BGR.

Code: Select all

PixelGetColor, OutputVar1, 500, 500, RGB
PixelGetColor, OutputVar2, 500, 500
MsgBox % Format("0x{:x}", OutputVar1) "`n" Format("0x{:x}", OutputVar2)

Go to advanced search