Search found 112 matches

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 ...
by JKnight_xbt33
09 Sep 2020, 07:42
Forum: Ask For Help
Topic: ComobjActive double backslash illegal character different address Topic is solved
Replies: 3
Views: 123

ComobjActive double backslash illegal character different address Topic is solved

Dear all, I found a great script and tested it works perfectly. I want to use a different address than A_temp. It will look like this: \\private\Users\JK\Documents\18-Customer complaint reports I get an error saying the double backslash is an illegal character. How would i replace A_temp in the scri...
by JKnight_xbt33
01 Sep 2020, 04:59
Forum: Ask For Help
Topic: How can I paste text containing linebreaks Topic is solved
Replies: 7
Views: 142

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

Thanks I tested this out on MS word and it worked perfectly, seems to be an issue with the program I am trying to paste into.

Will have to live with it and use {enter} to simulate the line breaks.

Appreciate your help
James
by JKnight_xbt33
31 Aug 2020, 16:56
Forum: Ask For Help
Topic: How can I paste text containing linebreaks Topic is solved
Replies: 7
Views: 142

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

Thanks for your help. BoBo I tried your script but unfortunately it pasted without any separation or linebreaks; just one block of text RubbeH I tried both your f5 and `n script. For the `n script I tested as below on notepad. with either script there was no separation of each line (see below attach...
by JKnight_xbt33
28 Aug 2020, 05:42
Forum: Ask For Help
Topic: How can I paste text containing linebreaks Topic is solved
Replies: 7
Views: 142

How can I paste text containing linebreaks Topic is solved

Dear all, I am trying to use my paste function to paste the variable called init. This variable contains multiple lines of text which I want to separate using line breaks. Reading up the documentation I am supposed to use `n, however its not working still pasting as one block without spaces. Is my p...

Go to advanced search