Search found 105 matches

by carno
06 Jun 2018, 04:33
Forum: Ask For Help
Topic: RegExReplace Question Topic is solved
Replies: 2
Views: 39

Re: RegExReplace Question Topic is solved

Absolutely perfect. Thanks!
by carno
06 Jun 2018, 04:09
Forum: Ask For Help
Topic: RegExReplace Question Topic is solved
Replies: 2
Views: 39

RegExReplace Question Topic is solved

I have the following data. Some lines have a leading (extra) space (such as lines Venture Data ... , Simply Fashion ... , Academy of Art ... etc. (Space at the beginning of lines.) I tried to remove these spaces only without affecting the other lines, but my best effort was this: RegExReplace(data, ...
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: 65

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: 178

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: 178

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: 178

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: 12643

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: 131

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: 131

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: 131

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: 131

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: 112

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: 112

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: 112

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: 98

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: 93

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: 93

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: 310

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: ...

Go to advanced search