Search found 117 matches

by JKnight_xbt33
13 Jan 2021, 05:22
Forum: Ask For Help
Topic: [Word COM] Printing document--print more than 1 copy
Replies: 18
Views: 1769

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...
by JKnight_xbt33
11 Jan 2021, 09:59
Forum: Ask For Help
Topic: [Word COM] Printing document--print more than 1 copy
Replies: 18
Views: 1769

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" ...
by JKnight_xbt33
07 Jan 2021, 10:13
Forum: Ask For Help
Topic: [Word COM] Printing document--print more than 1 copy
Replies: 18
Views: 1769

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...
by JKnight_xbt33
04 Jan 2021, 07:13
Forum: Ask For Help
Topic: [Word COM] Printing document--print more than 1 copy
Replies: 18
Views: 1769

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
by JKnight_xbt33
24 Dec 2020, 10:49
Forum: Ask For Help
Topic: Activate AHK with voice recongnition
Replies: 20
Views: 5902

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
by JKnight_xbt33
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: 211

Re: how to paste values of an excel range iteratively rather than all at once Topic is solved

Thank you both for your answers :bravo:

That's amazing, I've learnt about this offset concept and it will be immensely helpful in future.

I really appreciate it
J
by JKnight_xbt33
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: 211

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...
by JKnight_xbt33
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: 211

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...
by JKnight_xbt33
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: 211

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
by JKnight_xbt33
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: 211

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...
by JKnight_xbt33
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: 276

Re: How to use fileopen to open a file with excel cell.value variable Topic is solved

Thank you, the expression below worked perfectly

Code: Select all

run, % "C:\test\" . Cell.Value . " Customer Complaint Report.pdf"

appreciated
J
by JKnight_xbt33
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: 276

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 ...
by JKnight_xbt33
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: 276

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...
by JKnight_xbt33
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: 276

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 ...
by JKnight_xbt33
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: 276

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 ...
by JKnight_xbt33
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: 62

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...
by JKnight_xbt33
06 Oct 2020, 09:01
Forum: Ask For Help
Topic: store excel array as a variable Topic is solved
Replies: 4
Views: 109

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...
by JKnight_xbt33
05 Oct 2020, 05:31
Forum: Ask For Help
Topic: store excel array as a variable Topic is solved
Replies: 4
Views: 109

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...
by JKnight_xbt33
21 Sep 2020, 05:19
Forum: Ask For Help
Topic: How to see if specific checkbox is selected
Replies: 3
Views: 98

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...
by JKnight_xbt33
18 Sep 2020, 10:31
Forum: Ask For Help
Topic: How to see if specific checkbox is selected
Replies: 3
Views: 98

How to see if specific checkbox is selected

HI all, I've been trying to make a script that can read to see whether a specific checkbox is ticked. The problem is my PDF form has multiple checkboxes (examples circled in red in the picture). form checkboxes.PNG I tried to make a script based on the documentation on the site: - however it always ...

Go to advanced search