Search found 118 matches
- 11 Feb 2021, 08:32
- Forum: Ask For Help
- Topic: How can I paste text containing linebreaks Topic is solved
- Replies: 8
- Views: 203
Re: How can I paste text containing linebreaks Topic is solved
6 months later and I've figured out how to do it. Instead of using `n between lines I used `r`n and it worked perfectly. Seems the program I was using doesn't allow `n for linebreaks but allows `r`n. See below for example usage init := "1. text for line 1 bla bla bla bla`r`n2. text for line 2 bla bl...
- 13 Jan 2021, 05:22
- Forum: Ask For Help
- Topic: [Word COM] Printing document--print more than 1 copy
- Replies: 18
- Views: 1826
Re: [Word COM] Printing document--print more than 1 copy
Hi FanaticGuru , It printed in colour, turns out the syntax of the name of the printer was different. Regarding printing double sided it turns out it doesn't work like I thought. When i went ahead to print more than 2 pages it prints odd and even numbers as separate documents (which is what manuel d...
- 11 Jan 2021, 09:59
- Forum: Ask For Help
- Topic: [Word COM] Printing document--print more than 1 copy
- Replies: 18
- Views: 1826
Re: [Word COM] Printing document--print more than 1 copy
Hi FanaticGuru , Your script worked nicely for double sided print [ Edit: 13/01/2021 doesn't print a true double sided copy, only manual duplex] I just cant seem to get the active printer to work (line 5). Is there a specific naming convention I should use? printpath := A_Desktop "\Check List.docx" ...
- 07 Jan 2021, 10:13
- Forum: Ask For Help
- Topic: [Word COM] Printing document--print more than 1 copy
- Replies: 18
- Views: 1826
Re: [Word COM] Printing document--print more than 1 copy
FanaticGuru Thanks, regarding the color my workplace actually has it setup like you suggest i.e. color or black/white appear as two separate devices. reading the microsoft documentation there doesn't appear to be a parameter to select which printer the doc goes to. Do you know any alternative VBA r...
- 04 Jan 2021, 07:13
- Forum: Ask For Help
- Topic: [Word COM] Printing document--print more than 1 copy
- Replies: 18
- Views: 1826
Re: [Word COM] Printing document--print more than 1 copy
Hi @FanaticGuru and @derz00 ,
This is a fantastic script.
How would you get it to:
-print in color
-print double sided
thanks
This is a fantastic script.
How would you get it to:
-print in color
-print double sided
thanks
- 24 Dec 2020, 10:49
- Forum: Ask For Help
- Topic: Activate AHK with voice recongnition
- Replies: 20
- Views: 5985
Re: Activate AHK with voice recongnition
@Elgin
I've been looking at this thread as I am trying to do something similar.
Where is this speech recognition library located with all its functions?
Is it somewhere on the forums?
regards
J
I've been looking at this thread as I am trying to do something similar.
Where is this speech recognition library located with all its functions?
Is it somewhere on the forums?
regards
J
- 16 Nov 2020, 03:53
- Forum: Ask For Help
- Topic: how to paste values of an excel range iteratively rather than all at once Topic is solved
- Replies: 7
- Views: 246
Re: how to paste values of an excel range iteratively rather than all at once Topic is solved
Thank you both for your answers
That's amazing, I've learnt about this offset concept and it will be immensely helpful in future.
I really appreciate it
J

That's amazing, I've learnt about this offset concept and it will be immensely helpful in future.
I really appreciate it
J
- 13 Nov 2020, 09:45
- Forum: Ask For Help
- Topic: how to paste values of an excel range iteratively rather than all at once Topic is solved
- Replies: 7
- Views: 246
Re: how to paste values of an excel range iteratively rather than all at once Topic is solved
Sorry yeah its quite a complex script. In case anyone else sees the thread this is what I am trying to do with an example: test excel data.PNG 1. Cell A1 contains the number 2913 2. The script looks for a pdf report in the test folder which has 2913 in its filename test folder.PNG 3. the script open...
- 13 Nov 2020, 06:58
- Forum: Ask For Help
- Topic: how to paste values of an excel range iteratively rather than all at once Topic is solved
- Replies: 7
- Views: 246
Re: how to paste values of an excel range iteratively rather than all at once Topic is solved
An update on this I found a script on the forum: https://www.autohotkey.com/boards/viewtopic.php?t=48981 which I incorporated principles from. I am now able paste 1 row rather than all rows from column D by using "break" All that's left is for me to try and make a loop after each iteration so that t...
- 11 Nov 2020, 06:11
- Forum: Ask For Help
- Topic: how to paste values of an excel range iteratively rather than all at once Topic is solved
- Replies: 7
- Views: 246
Re: how to specify Excel Cell.Value to paste only one cell at a time from the range Topic is solved
@boiler your advice has been invaluable in my learning about excel and AHK.
Is there a way to paste the values of an excel range iteratively? rather than all at once
best
Is there a way to paste the values of an excel range iteratively? rather than all at once
best
- 30 Oct 2020, 12:04
- Forum: Ask For Help
- Topic: how to paste values of an excel range iteratively rather than all at once Topic is solved
- Replies: 7
- Views: 246
how to paste values of an excel range iteratively rather than all at once Topic is solved
Hi all, I have a script below. The idea is a matching PDF file is opened if it contains the same number from range A2:A3 The 2nd part of the script where I am stuck. There is supposed to be a ctrl f search in the file for a serial no which is from D2:D3 The problem is when it comes to pasting this r...
- 23 Oct 2020, 04:41
- Forum: Ask For Help
- Topic: How to use fileopen to open a file with excel cell.value variable Topic is solved
- Replies: 13
- Views: 304
Re: How to use fileopen to open a file with excel cell.value variable Topic is solved
Thank you, the expression below worked perfectly
appreciated
J
Code: Select all
run, % "C:\test\" . Cell.Value . " Customer Complaint Report.pdf"
appreciated
J
- 19 Oct 2020, 08:20
- Forum: Ask For Help
- Topic: How to use fileopen to open a file with excel cell.value variable Topic is solved
- Replies: 13
- Views: 304
Re: How to use fileopen to open a file with excel cell.value variable Topic is solved
Hi all thanks for the tips, I am indeed trying to open the pdf in a similar fashion to run. Also just formatted the text to number but it wont make a difference anyway since the message box outputted the cell.value as 2913 deleting the space to make the function fileopen ("C become fileopen("C lead ...
- 16 Oct 2020, 04:56
- Forum: Ask For Help
- Topic: How to use fileopen to open a file with excel cell.value variable Topic is solved
- Replies: 13
- Views: 304
Re: How to use fileopen to open a file with excel cell.value variable Topic is solved
hmm :think: Not sure what to make of this. The pdf still wont open so I thought it could be something wrong with: 1. The network path I am trying to open the pdf from. I used the c drive instead and still the pdf wouldnt open 2. the pdf naming convention. I used a wildcard as below and still same re...
- 15 Oct 2020, 08:53
- Forum: Ask For Help
- Topic: How to use fileopen to open a file with excel cell.value variable Topic is solved
- Replies: 13
- Views: 304
Re: How to use fileopen to open a file with excel cell.value variable Topic is solved
thanks boiler I didnt know about expressions so I'll keep this in mind next time. interestingly after trying the script suggestion, the PDF didnt open. the script it outputting the number from the message box correctly. I've attached a print screen of the pdf and the test excel table which may help ...
- 14 Oct 2020, 05:55
- Forum: Ask For Help
- Topic: How to use fileopen to open a file with excel cell.value variable Topic is solved
- Replies: 13
- Views: 304
How to use fileopen to open a file with excel cell.value variable Topic is solved
Dear all, I am trying to put together a short script which will open a pdf file which contains the variable in its file name that is taken from an excel cell contents. I am not sure how to store the cell.value as a variable in the filename (see the line that says fileopen). At the moment I only put ...
- 07 Oct 2020, 10:15
- Forum: Ask For Help
- Topic: Cant get RegExReplace and A_LoopReadLine to output numbers in a pdf Topic is solved
- Replies: 3
- Views: 72
Cant get RegExReplace and A_LoopReadLine to output numbers in a pdf Topic is solved
Dear all, I am trying to find a 13 digit number inside the PDF file that will start 3330 . I would like to store this number in a variable however I want to use messagebox to check the number has been found. I made a simple script below based on the little knowledge I know about regex. So far the me...
- 06 Oct 2020, 09:01
- Forum: Ask For Help
- Topic: store excel array as a variable Topic is solved
- Replies: 4
- Views: 119
Re: store excel array as a variable Topic is solved
All the answers were good, I chose the the loop script below because I wont have to hard code each cell into the script I can just specify a range. File2Open := A_Desktop "\Test\specificExcelFile.xlsx" xlApp := ComObjCreate( "Excel.Application" ) xlWB := xlApp.Workbooks.Open(File2Open) xlApp.Visible...
- 05 Oct 2020, 05:31
- Forum: Ask For Help
- Topic: store excel array as a variable Topic is solved
- Replies: 4
- Views: 119
store excel array as a variable Topic is solved
Dear all, I have an excel table with 5 columns (A to E) and 5 rows (1 TO 5) I want to store the output of each individual cell as a variable. I know how to output the array of columns but not each individual cell (see example below) Does anyone know how to do this. for example if I want to store the...
- 21 Sep 2020, 05:19
- Forum: Ask For Help
- Topic: How to see if specific checkbox is selected
- Replies: 3
- Views: 110
Re: How to see if specific checkbox is selected
mikeyww thanks , I used #if because the AHK documentation for checkboxes stated to use it. interestingly when removing the hash, the script didn't work at all whether checkbox was ticked or not. After doing a window spy I found that all the checkboxes share the same AHK class, pid and control as be...