Search found 448 matches

by AlphaBravo
9 minutes ago
Forum: Ask For Help
Topic: How to find duplicate lines? Topic is solved
Replies: 12
Views: 229

Re: How to find duplicate lines? Topic is solved

I don't mean to pick on you sinkfaze, but there is a flaw in the answer due to the use of StrReplace() try it on this input a= ( 1 2 3 32 2 1 ) b := a elements := [] loop, parse, b, `n, `r elements[A_LoopField] := elements[A_LoopField] ? elements[A_LoopField] + 1 : 1 for element, count in elements i...
by AlphaBravo
15 Jan 2019, 16:37
Forum: Ask For Help
Topic: Outlook in Windows 10 - UAC Issues
Replies: 17
Views: 1461

Re: Outlook in Windows 10 - UAC Issues

awel20 , Thanks for taking the time to elaborate on that and your input. Unfortunately the only thing I can suggest is making sure your script is running with the same level of privileges as Outlook. just like you suggested when I ran outlook with elevated privilege (run as admin) I was able to get ...
by AlphaBravo
12 Jan 2019, 13:53
Forum: Ask For Help
Topic: Outlook in Windows 10 - UAC Issues
Replies: 17
Views: 1461

Re: Outlook in Windows 10 - UAC Issues

I am working on a script that needs to run as admin, and came across the issue with ComObjActive not working with Outlook when elevated.
I found few posts discussing it but still did not find a solid solution.
has anyone got Acc_ObjectFromWindow to work on Outlook?
by AlphaBravo
12 Jan 2019, 12:20
Forum: Scripts and Functions
Topic: Reads Excel (xlsx) Fast
Replies: 14
Views: 2091

Re: Reads Excel (xlsx) Fast

Hello IMEime, I have noticed your reference to this script from "Comparing 2 excel Files takes Forever to finish" request, I gave it a bit of testing and while it is for sure faster than iterating through Excel cells via COM, I noticed that if a cells is formatted (Bold/Italic/Underlined/formatted a...
by AlphaBravo
12 Jan 2019, 11:08
Forum: Ask For Help
Topic: Script to rename files Topic is solved
Replies: 22
Views: 642

Re: Script to rename files Topic is solved

no worries, this should do it, I added a couple of lines oWord := {"à":"a", "á":"a", "ã":"a", "â":"a", "é":"e", "è":"e", "ê":"e" , "í":"i", "ì":"i", "ó":"o", "õ":"o", "ô":"o", "ò":"o", "ú":"u" , "ù":"u", "ç":"c", "À":"A", "Á":"A", "Ã":"A", "Â":"A", "É":"E" , "Ê":"E", "È":"E", "Í":"I", "Ì":"I", "Ó":"...
by AlphaBravo
12 Jan 2019, 02:51
Forum: Ask For Help
Topic: Script to rename files Topic is solved
Replies: 22
Views: 642

Re: Script to rename files Topic is solved

hello again, I see the issue, modified the script a little bit oWord := {"à":"a", "á":"a", "ã":"a", "â":"a", "é":"e", "è":"e", "ê":"e" , "í":"i", "ì":"i", "ó":"o", "õ":"o", "ô":"o", "ò":"o", "ú":"u" , "ù":"u", "ç":"c", "À":"A", "Á":"A", "Ã":"A", "Â":"A", "É":"E" , "Ê":"E", "È":"E", "Í":"I", "Ì":"I",...
by AlphaBravo
05 Jan 2019, 21:55
Forum: Ask For Help
Topic: RegExReplace - Address of Excel cell + Range Topic is solved
Replies: 4
Views: 128

Re: RegExReplace - Address of Excel cell + Range Topic is solved

(Instead of 2200 it could be the actual range, but 2200 should be enough in my case). what is the actual range ?? if the "actual range" is the last cell with data in the active column and is likely to be at a row number less than 2200 xl := ComObjActive("Excel.Application") col := xl.ActiveCell.Col...
by AlphaBravo
28 Dec 2018, 14:19
Forum: Ask For Help
Topic: Run programs and URL's in different windows.
Replies: 10
Views: 271

Re: Run programs and URL's in different windows.

depending on your Adobe Reader installation give this a try, it worked for me Run, C:\Program Files (x86)\Adobe\Reader 11.0\Reader\AcroRd32.exe %A_Desktop%\file1.pdf Run, C:\Program Files (x86)\Adobe\Reader 11.0\Reader\AcroRd32.exe %A_Desktop%\file2.pdf Run, chrome.exe /new-window http://www.google....
by AlphaBravo
28 Dec 2018, 14:02
Forum: Ask For Help
Topic: While Left Mouse Button is held down Script is paused
Replies: 2
Views: 89

Re: While Left Mouse Button is held down Script is paused

Code: Select all

Pause
SetTimer, running, 10
return

LButton::
Pause, off
return

LButton Up::
Pause, On
return

running:
ToolTip % A_TickCount
return
by AlphaBravo
27 Dec 2018, 21:22
Forum: Ask For Help
Topic: Help me out please..
Replies: 1
Views: 75

Re: Help me out please..

depending on the size of your clipboard, there might be few "atoms" of delay SetBatchLines, -1 Clipboard = (join`r`n mast mate meat team eats eats master monster mister make masterer religion intermidiate selection sin man send mind teams mint meat team errect archive masonette messi cookies ) num :...
by AlphaBravo
24 Dec 2018, 13:17
Forum: Ask For Help
Topic: Insert list of values one-at-a-time using looped script
Replies: 2
Views: 107

Re: Insert list of values one-at-a-time using looped script

there was a request not too long ago very similar to yours here: https://autohotkey.com/boards/viewtopic.php?f=76&t=59261 have one instance of Windows Explorer open, select your 8 files and run the following Prefix = ( 1_YPNP 2_EHRE 3_THNR 4_PTNH 5_ZZNN 6_PTTT 7_EQNH 8_ERQY ) Pre := StrSplit(Prefix,...
by AlphaBravo
19 Dec 2018, 09:39
Forum: Ask For Help
Topic: Directory containing Illegal characters
Replies: 2
Views: 61

Re: Directory containing Illegal characters

it works fine if you use Unicode version AHK.

Code: Select all

Run % A_Desktop "\tèmp"
but to answer your question

Code: Select all

transform, xx, chr, 0232
var  := "D:\ret"
var2 := "\one"
var3 = %var%%xx%%var2%		; < remove colon
MsgBox % var3

; or
var3 := var xx var2
MsgBox % var3
by AlphaBravo
18 Dec 2018, 20:00
Forum: Ask For Help
Topic: Variables inside Multi-Line Edit Topic is solved
Replies: 4
Views: 105

Re: Variables inside Multi-Line Edit Topic is solved

add submit

Code: Select all

examplebutton:
Gui, Submit, NoHide
; rest of code here
no variable named 'existingnumber' from what you posted
by AlphaBravo
16 Dec 2018, 11:22
Forum: Ask For Help
Topic: First Time Coding Need Help Please Topic is solved
Replies: 3
Views: 154

Re: First Time Coding Need Help Please Topic is solved

Welcome to the forum :)

Code: Select all

~LButton::
SetTimer, moveMouse, 300
return

~LButton up::
SetTimer, moveMouse, Off
return

moveMouse:
MouseMove, 0, 30, 0, R
return
by AlphaBravo
16 Dec 2018, 11:04
Forum: Ask For Help
Topic: I need help with using RegExReplace() function Topic is solved
Replies: 6
Views: 217

Re: I need help with using RegExReplace() function Topic is solved

what am I missing ??

Code: Select all

str =
(
Name, Firstname - City (blabla)).txt
Name1, Firstname1 - City1(tata.txt
)

loop, parse, str, `n, `r
	res .= RegExReplace(A_LoopField , "\s*\(.*(?=\.)") "`n"
MsgBox % res
by AlphaBravo
16 Dec 2018, 01:27
Forum: Ask For Help
Topic: multiple needles in a haystack but results not true to case in file read
Replies: 3
Views: 98

Re: multiple needles in a haystack but results not true to case in file read

update "find" subroutine, changed lines are marked with "<----" Find: ; Ran each time a char is added to search field Gui,Submit, Nohide Gui,listview, LV1 Array :={} ;~ StringLower, SRC, e1, ; <---- delete search:= % srch1 loop, parse, search, %A_Space% Array.Insert(A_LoopField) for index, element i...
by AlphaBravo
16 Dec 2018, 01:10
Forum: Ask For Help
Topic: I need help with using RegExReplace() function Topic is solved
Replies: 6
Views: 217

Re: I need help with using RegExReplace() function Topic is solved

Code: Select all

Outfilename := RegExReplace(Outfilename , "\s*\(.*(?=\.)")
by AlphaBravo
12 Dec 2018, 22:22
Forum: Ask For Help
Topic: Converting VBScript to AHK Topic is solved
Replies: 1
Views: 109

Re: Converting VBScript to AHK Topic is solved

it doesn't make sense to perform a search on row 1 cells after you set their values, but here you go: XL := ComObjActive("Excel.Application") ;starts excel nothing visible XL.Application.ActiveProtectedViewWindow.Edit xl.Sheets.Add(, xl.ActiveSheet) xl.Range("A1").Value := "Tower" xl.Range("B1").Val...
by AlphaBravo
12 Dec 2018, 21:59
Forum: Ask For Help
Topic: Script to rename files Topic is solved
Replies: 22
Views: 642

Re: Script to rename files Topic is solved

I added a condition to add "Prefix_" only if it doesn't already exists. abuse!!! :o , no such thing here :) oWord := {"à":"a", "á":"a", "ã":"a", "â":"a", "é":"e", "è":"e", "ê":"e" , "í":"i", "ì":"i", "ó":"o", "õ":"o", "ô":"o", "ò":"o", "ú":"u" , "ù":"u", "ç":"c", "À":"A", "Á":"A", "Ã":"A", "Â":"A", ...

Go to advanced search