Search found 420 matches

by Sabestian Caine
08 Sep 2016, 13:00
Forum: Ask For Help
Topic: How to remove specific values from clipboard?
Replies: 14
Views: 2298

Re: How to remove specific values from clipboard?

str = 07721000012345 or 07721000005007 or 07721000000009 or 07721000000013 or 07721000000410 MsgBox % RegExReplace(str, "\b077210+") "`nor`n" ; use the constant part "07721" for matching . RegExReplace(str, "\b0*\d*?0+") ; more dynamic Thanks dear AlphaBravo for providing me more dynamic codes. Tha...
by Sabestian Caine
08 Sep 2016, 12:43
Forum: Ask For Help
Topic: How to search a specific string which exists multiple times in a specific column in MS Excel?
Replies: 6
Views: 808

Re: How to search a specific string which exists multiple times in a specific column in MS Excel?

oExcel.Range("D:D").Find("This is a Test", oExcel.ActiveCell .EntireRow.Cells(1, 4) ).Select After The cell after which you want the search to begin. This corresponds to the position of the active cell when a search is done from the user interface. Notice that After must be a single cell in the ran...
by Sabestian Caine
07 Sep 2016, 13:07
Forum: Ask For Help
Topic: How to search a specific string which exists multiple times in a specific column in MS Excel?
Replies: 6
Views: 808

Re: How to search a specific string which exists multiple times in a specific column in MS Excel?

oExcel := ComObjActive("Excel.Application") return f1:: oExcel.Range("D:D").Find("This is a Test", oExcel.ActiveCell).Select return Thanks dear AlphaBravo for your reply... I tried to use these codes as suggested by you- oExcel := ComObjActive("Excel.Application") return f1:: oExcel.Range("D:D").Fi...
by Sabestian Caine
07 Sep 2016, 12:25
Forum: Ask For Help
Topic: How to search a specific string which exists multiple times in a specific column in MS Excel?
Replies: 6
Views: 808

How to search a specific string which exists multiple times in a specific column in MS Excel?

For example I have a string say “This is a Test” and this string exists in cell no d3, d10, d15 and d21 and when I press f1 key then it should first select d3. If I again press f1 key then it should select d10 and if I again press f1 key then it should select d15 and if I again press f1 key then it ...
by Sabestian Caine
06 Sep 2016, 13:37
Forum: Ask For Help
Topic: How to remove specific values from clipboard?
Replies: 14
Views: 2298

Re: How to remove specific values from clipboard?

Thanks dear shadowpheonix for making me understand all these things in so easy way. sir as i want to remove all the numeric digits i.e. 70,000.00 14,700.00 3,000.00 from the above series and want to keep only these values- 12-08-16 12-08-16 12-08-16 12-08-16 DL10587 DL10575 DL11318 DL2514 DL8526 DL...
by Sabestian Caine
05 Sep 2016, 11:16
Forum: Ask For Help
Topic: How to remove specific values from clipboard?
Replies: 14
Views: 2298

Re: How to remove specific values from clipboard?

Thanks dear shadowpheonix for making me understand all these things in so easy way. sir as i want to remove all the numeric digits i.e. 70,000.00 14,700.00 3,000.00 from the above series and want to keep only these values- 12-08-16 12-08-16 12-08-16 12-08-16 DL10587 DL10575 DL11318 DL2514 DL8526 DL...
by Sabestian Caine
04 Sep 2016, 12:37
Forum: Ask For Help
Topic: How to rename all folders, sub folders and files?
Replies: 4
Views: 714

Re: How to rename all folders, sub folders and files?

For what you want to do, you will need to rename the files & folders one at a time. However, you can use a file-pattern loop to do so. Thanks dear Shadowpheonix for your kind reply.... Dear Shadowpheonix i tried to use these codes to rename all the sub folders and files existing in a MainFolder. Bu...
by Sabestian Caine
02 Sep 2016, 13:17
Forum: Ask For Help
Topic: How to remove specific values from clipboard?
Replies: 14
Views: 2298

Re: How to remove specific values from clipboard?

F1:: Clipboard := Trim(RegExReplace(Clipboard, "m)^(\d\d-\d\d-\d\d)$|^(D[^\d]?\d*)$", ""), " `r`n`t") ; This will work even if the dates change. Return Dear shadowpheonix...could you please make me understand why these codes have been used like this here. I tried to read the documentation part of R...
by Sabestian Caine
01 Sep 2016, 14:12
Forum: Ask For Help
Topic: How to rename all folders, sub folders and files?
Replies: 4
Views: 714

How to rename all folders, sub folders and files?

Dear friends i want to change the name of all sub folders and files of a main folder. For example there is a folder say c:\main folder, and in c:\main folder there is one sub folder say sub folder1 and one txt file say 1.txt and in that sub folder1 there is one more sub folder say sub folder2 and on...
by Sabestian Caine
28 Aug 2016, 13:05
Forum: Ask For Help
Topic: How to remove specific values from clipboard?
Replies: 14
Views: 2298

Re: How to remove specific values from clipboard?

F1:: Clipboard := Trim(RegExReplace(Clipboard, "m)^(\d\d-\d\d-\d\d)$|^(D[^\d]?\d*)$", ""), " `r`n`t") ; This will work even if the dates change. Return Dear shadowpheonix...could you please make me understand why these codes have been used like this here. I tried to read the documentation part of R...
by Sabestian Caine
28 Aug 2016, 12:23
Forum: Ask For Help
Topic: How to disable a hotkey when excel sheet is in editing mode and enable it later on? Topic is solved
Replies: 8
Views: 829

Re: How to disable a hotkey when excel sheet is in editing mode and enable it later on? Topic is solved

Try this: #IfWinActive, ahk_class XLMAIN $n:: xlApp := ComObjActive("Excel.Application") Try If xlApp.Selection.Row <= 10 && xlApp.Selection.Column <= 4 { Flag := "Inside" Send, new } Else { Flag := "Outside" Send, n } Catch If (Flag = "Inside") Send, new Else Send, n Return #If I hope that helps. ...
by Sabestian Caine
28 Aug 2016, 08:40
Forum: Ask For Help
Topic: How to disable a hotkey when excel sheet is in editing mode and enable it later on? Topic is solved
Replies: 8
Views: 829

Re: How to disable a hotkey when excel sheet is in editing mode and enable it later on? Topic is solved

You're turning the hotkey off when you click outside the range. Then when you click inside again, there is no hotkey to catch it. Just remove the hotkey, $n, off and you should be good. Thanks dear punchin for your kind reply. Sir when i remove hotkey off command and then i press hotkey "n" twice i...
by Sabestian Caine
26 Aug 2016, 12:32
Forum: Ask For Help
Topic: How to disable a hotkey when excel sheet is in editing mode and enable it later on? Topic is solved
Replies: 8
Views: 829

Re: How to disable a hotkey when excel sheet is in editing mode and enable it later on? Topic is solved

Use a ~ in front of the n. That allows it to flow throw and operate as normal as well as the hotkey. Use can also the catch section as an "else" portion of the try command. $ n:: Try { Your code } Catch { Send, n } Thanks dear punchin for your good assistance. Dear punchin i created these codes wit...
by Sabestian Caine
25 Aug 2016, 05:34
Forum: Ask For Help
Topic: How to disable a hotkey when excel sheet is in editing mode and enable it later on? Topic is solved
Replies: 8
Views: 829

Re: How to disable a hotkey when excel sheet is in editing mode and enable it later on? Topic is solved

You can disable it with the hotkey command or just enclose it in a try block to bypass the error while it wont work. Thanks dear punchin for your kind reply.... I tried to read documentation part for hotkey command and try command but I could not understand much..... I tried to use codes with try c...
by Sabestian Caine
24 Aug 2016, 13:06
Forum: Ask For Help
Topic: How to disable a hotkey when excel sheet is in editing mode and enable it later on? Topic is solved
Replies: 8
Views: 829

How to disable a hotkey when excel sheet is in editing mode and enable it later on? Topic is solved

Dear friends i have these codes- $n:: xlApp := ComObjActive("Excel.Application") if (xlApp.Selection.Row <= 10) and (xlApp.Selection.Column <= 4) { send new } else { send n } return In the above codes I want that when I press hotkey “n” in range a1:d10 then it should send “new” otherwise it should s...
by Sabestian Caine
24 Aug 2016, 00:03
Forum: Ask For Help
Topic: Need your help with passing COM variabless over different running AHK scripts
Replies: 2
Views: 462

Re: Need your help with passing COM variabless over different running AHK scripts

I got this to work by creating a ie_com object / client script and including it in the scripts that I wanted to control the client. Press the Download button below and save the script ie_com.ahk if !WinExist( "ahk_exe iexplore.exe" ) ; < this needs to be refined more! ieObj := ComObjCreate( "Intern...
by Sabestian Caine
23 Aug 2016, 00:42
Forum: Ask For Help
Topic: How to select a cell of a specific data range (column) which contains any value in MS Excel?
Replies: 2
Views: 576

Re: How to select a cell of a specific data range (column) which contains any value in MS Excel?

friends i created these codes by which i can select a cell which contains any value in column q but sometimes these codes gives error- columnQ:=1 f1:: xl:= ComObjActive("Excel.Application") while (xl.range("q"columnQ).value="") columnQ++ xl.range("q"columnQ).select columnQ++ return Please provide me...
by Sabestian Caine
20 Aug 2016, 05:01
Forum: Ask For Help
Topic: How to select a cell of a specific data range (column) which contains any value in MS Excel?
Replies: 2
Views: 576

Re: How to select a cell of a specific data range (column) which contains any value in MS Excel?

Friends i have these codes which searches any specific value in the specific column- f1:: xl:=comobjactive("excel.application") xl.Cells.Find("FINDWHAT", xl.ActiveCell, -4163, 2, 1, 1, False, False).Activate return But i need to select a cell which contains any value in a range. Seeking for your kin...
by Sabestian Caine
19 Aug 2016, 12:40
Forum: Ask For Help
Topic: How to select a cell of a specific data range (column) which contains any value in MS Excel?
Replies: 2
Views: 576

How to select a cell of a specific data range (column) which contains any value in MS Excel?

Dear ahk gurus first of all I appreciate your skills and zeal of helping newbies like me. Friends I want that when I press f1 key then it should select that cell of a specific data range (column) which contains any value i.e. which is not blank. For example I have a range say A1:A40 and there are va...
by Sabestian Caine
19 Aug 2016, 12:26
Forum: Ask For Help
Topic: How to search any four digit value in a specific column in ms Excel?
Replies: 3
Views: 480

Re: How to search any four digit value in a specific column in ms Excel?

Read up on Excel COM Controls. A google search will give you a few articles. You'll want to loop through column Q until you get a blank cell. Every cell should be checked for string length and the 4 digit cells can be stored with thier cell reference in an array. From there you can jump around the ...

Go to advanced search