AutoHotkey Community

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

Hi @FanaticGuru and @derz00 ,
This is a fantastic script.

How would you get it to:
-print in color
-print double sided

thanks

JKnight_xbt33

@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

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

@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

JKnight_xbt33

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

JKnight_xbt33

Thank you, the expression below worked perfectly

Code: Select all

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

appreciated
J

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

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

JKnight_xbt33

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

Search found 118 matches

Re: How can I paste text containing linebreaks Topic is solved

Re: [Word COM] Printing document--print more than 1 copy

Re: [Word COM] Printing document--print more than 1 copy

Re: [Word COM] Printing document--print more than 1 copy

Re: [Word COM] Printing document--print more than 1 copy

Re: Activate AHK with voice recongnition

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

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

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

Re: how to specify Excel Cell.Value to paste only one cell at a time from the range Topic is solved

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

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

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

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

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

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

Cant get RegExReplace and A_LoopReadLine to output numbers in a pdf Topic is solved

Re: store excel array as a variable Topic is solved

store excel array as a variable Topic is solved

Re: How to see if specific checkbox is selected