Search found 104 matches

by codude
Yesterday, 10:41
Forum: Ask For Help
Topic: Issues working with two Excel files
Replies: 8
Views: 205

Re: Issues working with two Excel files

It seems when I run both books with one instance of Excel just because one particular book is on the top screen, even a simple command like "MouseMove, % A_CaretX, % A_CaretY " needs to know which book to deal with. Is this correct?
by codude
18 Apr 2019, 12:39
Forum: Ask For Help
Topic: Issues working with two Excel files
Replies: 8
Views: 205

Re: Issues working with two Excel files

Hello, sorry I’ve been slow to respond to these solutions here but I got called out of town. After reading the 1st post from FG I tried running Book1 and Book2 in just one instance of Excel (I was running 2 before) and it seemed to solve the problem. This worked for an hour or so and then I started ...
by codude
12 Apr 2019, 10:25
Forum: Ask For Help
Topic: Issues working with two Excel files
Replies: 8
Views: 205

Issues working with two Excel files

Hello, I am working with two XL files (Book1 and Book2) in some script and if book 1 was the active screen this was working fine. oExcel := ComObjActive("Excel.Application") Row := oExcel.ActiveCell.Row ItemTDV := oExcel.Cells(Row, 1).text PatternItemIDV := oExcel.Cells(Row, 2).text ExcelModelV := o...
by codude
10 Nov 2018, 10:12
Forum: Ask For Help
Topic: Question about using WinSet
Replies: 1
Views: 135

Question about using WinSet

Hello, in a rather lengthy script I run a URL that takes a takes a fair amount time to load. So that it is loaded and ready for use when I need it I run the URL early on in the script. I don’t want it to appear until I’m ready for it so each time the script activates another window it “WinSet, Alway...
by codude
05 Nov 2018, 08:51
Forum: Ask For Help
Topic: Need to modify a string
Replies: 4
Views: 227

Re: Need to modify a string

Thanks jeeswg... That seems to have cleaned this up.
by codude
05 Nov 2018, 07:07
Forum: Ask For Help
Topic: Need to modify a string
Replies: 4
Views: 227

Re: Need to modify a string

Hello, It now seems the solution from swagfag was not just what I needed. If I start with this string "This 456-mh-666-g-87 Part" I need to end up with this "This 456-MH-666-G-87 Part" and I am getting this "THIS 456-MH-666-G-87 PART". I just want letters that are attached to numbers with "-" to be ...
by codude
30 Oct 2018, 07:21
Forum: Ask For Help
Topic: Combining conditions with different SetTitleMatchMode values.
Replies: 2
Views: 149

Re: Combining conditions with different SetTitleMatchMode values.

At first I tried this script in a standalone application and it seemed to work fine. When I incorporated it into my regular script it stopped working. I noticed that when I checked “cond1” on its own it kept showing that Pictures.ahk did exist even though it seemed that it did not. I went to AutoHot...
by codude
29 Oct 2018, 19:01
Forum: Ask For Help
Topic: Combining conditions with different SetTitleMatchMode values.
Replies: 2
Views: 149

Combining conditions with different SetTitleMatchMode values.

I have 4 or 5 hotkeys that I want to be able to use only if both of these conditions are met. DetectHiddenWindows, On SetTitleMatchMode, 2 IfWinNotExist, Pictures.ahk -And- SetTitleMatchMode, 1 IFWinActive, Microsoft Excel - Interchange.xlsm I’m guessing I need to somehow combine these 2 conditions ...
by codude
23 Oct 2018, 13:31
Forum: Ask For Help
Topic: string split results
Replies: 6
Views: 252

Re: string split results

I've got so much to learn here. I've been trying to get by with 1.21 for years now because I did not want to mess with what seemed like a good thing. I went ahead and updated to 1.30 and the original script from swagfag now works fine and so far everything else seems to be okay. I guess time will te...
by codude
23 Oct 2018, 11:50
Forum: Ask For Help
Topic: string split results
Replies: 6
Views: 252

Re: string split results

Thanks for taking the time to respond here. I'm getting a error here. "Error: Too many parameters passed to Function" I went back to the AHK String Split page and tried to change a few things but I'm not able to get this.
by codude
23 Oct 2018, 09:46
Forum: Ask For Help
Topic: string split results
Replies: 6
Views: 252

string split results

When I run this str = Red Green Blue \Big\Small\Med s:=StrSplit(str,"\") T1:= s.1 T2:= s.2 MsgBox % T1 MsgBox % T2 T1 is good for me but T2 equals "Big". I want "\Big|Small\Med" (With all 3 back slashes). In some cases there may be more or less back slashes. I just want everything after the first on...
by codude
21 Oct 2018, 13:47
Forum: Ask For Help
Topic: Help using variables and expressions
Replies: 2
Views: 93

Re: Help using variables and expressions

Thank-You! That did it.
by codude
21 Oct 2018, 13:26
Forum: Ask For Help
Topic: Help using variables and expressions
Replies: 2
Views: 93

Help using variables and expressions

This works fine for me. F4:: Computer = 1 Return F5:: Computer = 2 Return F6:: NumPad = 1 Return F7:: NumPad = 2 Return #If (NumPad = 1) & (Computer = 1) =:: Soundbeep Soundbeep Return #If #If (NumPad = 2) & (Computer = 1) =:: Soundbeep Return #If To make the script easier to understand I tried this...
by codude
17 Oct 2018, 16:46
Forum: Ask For Help
Topic: Need to modify a string
Replies: 4
Views: 227

Need to modify a string

This works to make all letters in a string that are connected to digits uppercase. For example makes bb30 go to BB30 or 30bb go to 30BB. SubstrUpperCase := RegExReplace(SubstrUpperCase, "\b([a-zA-Z]*)(\d+)([a-zA-Z]*)\b", "$U1$2$U3") I now need to make bb-30 go to BB-30 or 30-bb go to 30-BB. I tried ...
by codude
17 Oct 2018, 16:23
Forum: Ask For Help
Topic: Value of a Excel cell in selected row
Replies: 4
Views: 274

Re: Value of a Excel cell in selected row

That works for me. . I was somewhat confused with the "\d+" but after researching it I think I understand what is happening here. Thanks for the help.
by codude
16 Oct 2018, 15:03
Forum: Ask For Help
Topic: Value of a Excel cell in selected row
Replies: 4
Views: 274

Value of a Excel cell in selected row

This works to get a value of cell B2 in an active Excel sheet. oExcel:=ComObjActive("Excel.Application") value := oExcel.Range("B2").Value MsgBox % value I need to get the value of the B cell in any particular row that has been selected. I also need to mouse click a URL that is in Row C of the same ...
by codude
11 Oct 2018, 22:37
Forum: Ask For Help
Topic: Excell Cell offset
Replies: 4
Views: 250

Re: Excell Cell offset

Perfect! Thanks for taking the time to help me out here.
by codude
10 Oct 2018, 23:46
Forum: Ask For Help
Topic: Excell Cell offset
Replies: 4
Views: 250

Re: Excell Cell offset

Hello, Thank you for the help here. Your script ran fine when I tab through the cells without entering data but when I add data and then try tabbing to the next cell I get a error message. "Error 0X8001000 - Call was rejected by callee. Specifically: ActiveCell. Then there is a arrow pointing to thi...
by codude
10 Oct 2018, 08:22
Forum: Gaming
Topic: Wait to display Google web page till needed
Replies: 2
Views: 457

Re: Wait to display Google web page till needed

I stumbled across “WinSet, AlwaysOnTop” and it is working for me. Thanks
by codude
10 Oct 2018, 08:11
Forum: Ask For Help
Topic: Excell Cell offset
Replies: 4
Views: 250

Excell Cell offset

In a MS Excel project this works for me. XL := ComObjActive("Excel.Application") Cell_value = % XL.ActiveCell.value XL.ActiveCell.Offset(1,-3).Activate I want to apply this after I tab from any cell I might be in in column “G”. I have a hot key that I have tied to the “Tab” key and I’m thinking I ne...

Go to advanced search