Search found 103 matches

by carno
17 Apr 2018, 08:07
Forum: Ask For Help
Topic: How to escape double quotes in this example? Topic is solved
Replies: 2
Views: 55

How to escape double quotes in this example? Topic is solved

I try to escape double quotes in the following example: name1 .= " <media src=" " a_loopfilefullpath " "/> " "`r`n" Inside the first " " I enter src=" and inside the second " " I enter "/> but this obviously generates errors. I al...
by carno
14 Mar 2018, 19:32
Forum: Ask For Help
Topic: Help to find the active tab number in Firefox Topic is solved
Replies: 5
Views: 113

Re: Help to find the active tab number in Firefox Topic is solved

Thanks VERY much!! It works beautifully and that's all I wanted. Just the tab order number and it works like magic.
by carno
14 Mar 2018, 17:59
Forum: Ask For Help
Topic: Help to find the active tab number in Firefox Topic is solved
Replies: 5
Views: 113

Re: Help to find the active tab number in Firefox Topic is solved

Thanks! Are you specifically referring to this part of your code?: JEE_FirefoxFocusTabByName(hWnd, vTitle, vNum=1) { oAcc := Acc_Get("Object", "4", 0, "ahk_id " hWnd) vRet := 0 for each, oChild in Acc_Children(oAcc) if (oChild.accName(0) == "Browser tabs") { o...
by carno
14 Mar 2018, 17:02
Forum: Ask For Help
Topic: Help to find the active tab number in Firefox Topic is solved
Replies: 5
Views: 113

Help to find the active tab number in Firefox Topic is solved

I would like to get the tab number of the active tab I am reading in Firefox. By tab number I am referring to the order (sequence) number of the tab from the left. If it is the left-most (first) tab, then the number should be 1. if it is the second tab from the left the number should be 2, etc.
by carno
11 Mar 2018, 10:04
Forum: Scripts and Functions
Topic: Ticker: An RSS Scroller
Replies: 78
Views: 12503

Re: Ticker: An RSS Scroller

I tested the latest version on my XP and it works great!

AutoHotkey : v1.1.24.04 Unicode 32-bit (Installed)
SystemOS : WIN_XP 32-bit Service Pack 2 v5.1.2600 (WIN32_NT)
by carno
10 Mar 2018, 00:10
Forum: Ask For Help
Topic: find, match and fill cells in Excel spreadsheets Topic is solved
Replies: 5
Views: 115

Re: find, match and fill cells in Excel spreadsheets Topic is solved

I'm still on Excel 2003 so IFERROR does not work. However, I found this one working perfectly!

Code: [Select all]GeSHi © Codebox Plus

=IF(ISERROR(VLOOKUP(C1,$A$1:$B$100,2,FALSE)),"Not Found",VLOOKUP(C1,$A$1:$B$100,2,FALSE))
by carno
09 Mar 2018, 18:57
Forum: Ask For Help
Topic: find, match and fill cells in Excel spreadsheets Topic is solved
Replies: 5
Views: 115

Re: find, match and fill cells in Excel spreadsheets Topic is solved

Thanks a lot Guru, I'll try and let you all know.
by carno
09 Mar 2018, 17:56
Forum: Ask For Help
Topic: find, match and fill cells in Excel spreadsheets Topic is solved
Replies: 5
Views: 115

Re: find, match and fill cells in Excel spreadsheets Topic is solved

Yes, that is correct. Or I could copy sheet 2 columns into sheet 1 and have 4 columns A, B, C, D. Then look at column C and if it finds it in column A then copies from from column B (translation of term in column A) to column D (translation of column C). Column A | Column B | Column C | Column D ter...
by carno
09 Mar 2018, 15:47
Forum: Ask For Help
Topic: find, match and fill cells in Excel spreadsheets Topic is solved
Replies: 5
Views: 115

find, match and fill cells in Excel spreadsheets Topic is solved

I have Excel sheet 1 with 2 column A and B. Column A contains Japanese (kanji) terms and Column B contains their English translations. Excel sheet 2 also contains 2 columns A and B. Column A contains non-English terms and Column B contains no translations. I could copy Columns A and B from sheet 2 t...
by carno
26 Feb 2018, 16:47
Forum: Ask For Help
Topic: Closing open Excel files safely without saving them Topic is solved
Replies: 4
Views: 101

Re: Closing open Excel files safely without saving them Topic is solved

Microsoft site (https://msdn.microsoft.com/en-us/vba/excel-vba/articles/workbook-close-method-excel) states: Example: This example closes Book1.xls and discards any changes that have been made to it. Workbooks("BOOK1.XLS").Close SaveChanges:=False I believe this is the opposite. I tested m...
by carno
26 Feb 2018, 13:40
Forum: Ask For Help
Topic: Closing open Excel files safely without saving them Topic is solved
Replies: 4
Views: 101

Re: Closing open Excel files safely without saving them Topic is solved

Thanks, I hope this will not cause any damages. (In the past, I force-closed Excel processes and did some damage. I had to reinstall the Excel.)

Code: [Select all]GeSHi © Codebox Plus

Process, Close, Excel.exe
:shock:
by carno
26 Feb 2018, 13:24
Forum: Ask For Help
Topic: Closing open Excel files safely without saving them Topic is solved
Replies: 4
Views: 101

Closing open Excel files safely without saving them Topic is solved

I understand the following code works to close Excel files and saving them ( http://www.autohotkey.com/board/topic/80771-excel-close-and-save-all-invisible-workbooks/ ). However, I would like to close several files without saving any of them. Any suggestions? PS: In the past, I force-closed Excel pr...
by carno
20 Feb 2018, 08:50
Forum: Ask For Help
Topic: How to find left-side-center click coordinates of any screen automatically? Topic is solved
Replies: 3
Views: 88

How to find left-side-center click coordinates of any screen automatically? Topic is solved

I would like to find the click coordinates for the left-side-center (left edge center) of any screen (regardless of the screen size) automatically through a script so that I can use those numbers in Click x, y. Currently, I can find x and y mnaually using AutoScriptWriter or AutoIt3 Window Spy. PS: ...
by carno
13 Feb 2018, 11:58
Forum: Ask For Help
Topic: RegExMatch Assistance Topic is solved
Replies: 2
Views: 81

Re: RegExMatch Assistance Topic is solved

Thanks, the first one is what I was looking for. The second one is like my RegExMatch but much simpler.
by carno
13 Feb 2018, 07:03
Forum: Ask For Help
Topic: RegExMatch Assistance Topic is solved
Replies: 2
Views: 81

RegExMatch Assistance Topic is solved

I am seeking a RegExMatch that gives me all the text from the first char to the last char, nothing less and nothing more. My RegExMatch below has a problem. It gives me one extra new line (return or feed \n\r at the end). I would like the match to stop at the very last char and no further \n\r at th...
by carno
06 Feb 2018, 08:19
Forum: Scripts and Functions
Topic: [Func] Split Text keep delimiters | Split Text in lines by punctuation
Replies: 7
Views: 289

Re: [Func] Split Text keep delimiters | Split Text in lines by punctuation

Thanks! More extensive test: teststring:="This is a test??? This is a test2... This is a test3[] This is a test4!!? This is a test!!! This is a test> This is a test/ This is a text\ This is a text| This is a test^ This is a test- This is a test~ This is a test~~ This is a test' This is a test: ...
by carno
31 Dec 2017, 07:50
Forum: Ask For Help
Topic: RegEx back tick modifier question Topic is solved
Replies: 3
Views: 121

Re: RegEx back tick modifier question Topic is solved

Thanks SirRFI for answering my question. I did not know the link your provided existed and that solved my problem. I was not trying to achieve any particular RegEx pattern, but rather was studying and learning RegEx through examples and came across this one as an exercise.
by carno
31 Dec 2017, 03:13
Forum: Ask For Help
Topic: RegEx back tick modifier question Topic is solved
Replies: 3
Views: 121

RegEx back tick modifier question Topic is solved

Happy New Year! I was analyzing the following code and could not understand the meaning of modifiers `am) [I think modifier m) stands for multiline but my big question is regarding `a) or `a (specifically the meaning and function of the back quote or back tick also called "grave accent" he...

Go to advanced search