Search found 55 matches

by JKnight_xbt33
25 Mar 2020, 10:42
Forum: Ask For Help
Topic: Sending a variable to a user input box Topic is solved
Replies: 7
Views: 189

Re: Sending a variable to a user input box Topic is solved

I understand now. This is the first time I had seen 2 returns in the same block of code so didnt know what to make of it. The code is working perfectly and here it is (time reduced) for anyone who may find this useful setkeydelay , -1 WinGet,ID,ID,A InputBox, complaint, Enter complaint WinActivate,a...
by JKnight_xbt33
25 Mar 2020, 06:23
Forum: Ask For Help
Topic: Sending a variable to a user input box Topic is solved
Replies: 7
Views: 189

Re: Sending a variable to a user input box Topic is solved

Hi boiler , I tried using the first part of your code on its own error: Target label does not exist SetTimer, SendEnter, -3000 InputBox, folder, Enter folder,,,,,,,,, %complaint% return However after adding the sendEnter: part of your code as below then it worked somewhat but run into an issue. SetT...
by JKnight_xbt33
20 Mar 2020, 05:16
Forum: Ask For Help
Topic: Sending a variable to a user input box Topic is solved
Replies: 7
Views: 189

Re: Sending a variable to a user input box Topic is solved

SuperFoobar thanks your suggestion worked correctly! See below changed script. InputBox, folder, Enter folder,,,,,,,,, %complaint% Question: Is there a way to automatically press ok on the input box without having to manually press enter? If i add a sleep and send enter this doesn't work.See below ...
by JKnight_xbt33
19 Mar 2020, 09:33
Forum: Ask For Help
Topic: Sending a variable to a user input box Topic is solved
Replies: 7
Views: 189

Sending a variable to a user input box Topic is solved

Dear all, I searched the threads but this has alluded me. I am trying to send the variable %complaint% to the 2nd user input box that appears in my script. Avoiding the need to manually type it. The user input box uses control class Edit1. Is there a correct way to send variables to input boxes? Usi...
by JKnight_xbt33
12 Mar 2020, 04:42
Forum: Ask For Help
Topic: Loop Read not working on a specific field Topic is solved
Replies: 3
Views: 181

Re: Loop Read not working on a specific field Topic is solved

Thanks for your response. ControlGetText did what I was looking for.....sort of. It grabs the text from the field which is great. However I wanted to only grab the numerical portion of the text. Overall though I can work with this for now, not a big deal. Appreciate your simple answer and help Best ...
by JKnight_xbt33
11 Mar 2020, 10:22
Forum: Ask For Help
Topic: Loop Read not working on a specific field Topic is solved
Replies: 3
Views: 181

Loop Read not working on a specific field Topic is solved

Dear all, I've used Loop read very successfully to read the numbers from text files. For some reason when trying to read an edit field and trying to send this to notepad this isn't working. winTitle := "Customer Complaint - Occurrence Details - Q-Pulse" winClass := "ahk_class WindowsForms10.Window.8...
by JKnight_xbt33
10 Mar 2020, 05:25
Forum: Ask For Help
Topic: Increase reliability of my script? Topic is solved
Replies: 2
Views: 161

Re: Increase reliability of my script? Topic is solved

Thanks for your response, I used your script. It didnt work as intended because it proceeded to edit1 before the save as window was active. So i experimented and put back the sleep after the winwait active and it worked perfectly. Also another note is compared to my send command the ControlSetText,E...
by JKnight_xbt33
06 Mar 2020, 06:57
Forum: Ask For Help
Topic: Increase reliability of my script? Topic is solved
Replies: 2
Views: 161

Increase reliability of my script? Topic is solved

Dear all, My script I have a script which allows me to enter a complaint number in an input box. Saves this number as a variable. Waits for save-as window to pop up. Pushes this variable to the filename box. InputBox, complaint, Enter complaint sleep, 1500 send ^+{s} ;shortcut for file-> save as Win...
by JKnight_xbt33
04 Mar 2020, 07:49
Forum: Ask For Help
Topic: Excel Text to column script not working? Topic is solved
Replies: 5
Views: 230

Re: Excel Text to column script not working? Topic is solved

Thanks for your responses both.
I've selected TLM answer because it was the simplest for me to understand and re-use later.

Appreciate the support
:dance:
by JKnight_xbt33
02 Mar 2020, 11:13
Forum: Ask For Help
Topic: Excel Text to column script not working? Topic is solved
Replies: 5
Views: 230

Excel Text to column script not working? Topic is solved

Dear all, I made a text to column script after reading these threads. I am pretty sure it worked a few weeks back after testing on a few excel files. Have i accidentally deleted some important code ^!b:: ;deliminates 1st column to get data separated into columns xl:= ComObjActive("Excel.Application"...
by JKnight_xbt33
17 Feb 2020, 04:16
Forum: Ask For Help
Topic: Extracting info from PDF fields and copying into text fields Topic is solved
Replies: 8
Views: 411

Re: Extracting info from PDF fields and copying into text fields Topic is solved

So I've managed to bootlet a manual version of this. Even though its a simulation of what I would do manually to get the info from the PDF file its still pretty damn fast. All I had to do is grab each field in then PDF file and assign it a variable, then send each variable to the other window of int...
by JKnight_xbt33
07 Feb 2020, 06:20
Forum: Ask For Help
Topic: Extracting info from PDF fields and copying into text fields Topic is solved
Replies: 8
Views: 411

Re: Extracting info from PDF fields and copying into text fields Topic is solved

Fair enough, I've decided to think outside the box for my solution. 1. I could somehow do a loopreadline on the pdf and make each field into a pseudo array index. Then send these index arrays into the edit control fields of the programme of interest. so far my code for this isn't working: ^!w:: Loop...
by JKnight_xbt33
06 Feb 2020, 07:12
Forum: Ask For Help
Topic: Extracting info from PDF fields and copying into text fields Topic is solved
Replies: 8
Views: 411

Re: Extracting info from PDF fields and copying into text fields Topic is solved

Thanks for your answer FanaticGuru Alas I have the free version. 1. Do you know how to call the free version as comobject? I've looked at a few threads to use comobject on pdf but they all use the pro version ("AcroExch.App") 2. Once I know how to call free PDF versions I wanted to adjust your f11 c...
by JKnight_xbt33
05 Feb 2020, 05:17
Forum: Ask For Help
Topic: Extracting info from PDF fields and copying into text fields Topic is solved
Replies: 8
Views: 411

Extracting info from PDF fields and copying into text fields Topic is solved

HI all, In the picture below, I am trying to get info from the PDF fields on the right (blacked out) and copy them over into the text fields of the window on the left. PDF & window with text fields.PNG I've looked at a few threads but they are saying use a PDF converter. I don't want to do that,...
by JKnight_xbt33
02 Feb 2020, 07:09
Forum: Ask For Help
Topic: Iterative loop not working Topic is solved
Replies: 3
Views: 234

Re: Iterative loop not working Topic is solved

Thanks @boiler I knew it had to be something simple.

Also thanks @Tcharr I used your suggestion and it sends perfectly now.

:dance:
by JKnight_xbt33
01 Feb 2020, 11:35
Forum: Ask For Help
Topic: Iterative loop not working Topic is solved
Replies: 3
Views: 234

Iterative loop not working Topic is solved

Hello all, I had a working script which I wanted to adapt. It iteratively reads each line in a txt file and runs a send command for each line. working script Loop, Read, C:\Users\JK\18-reports PDFs\id.txt IDArr%A_Index%:= RegExReplace(A_LoopReadLine, "\D") While % IDArr%A_index% send % "FileCopy, C:...
by JKnight_xbt33
30 Jan 2020, 06:33
Forum: Ask For Help
Topic: Copyng an email from sent items folder into C:\Users\folder Topic is solved
Replies: 11
Views: 533

Re: Copyng an email from sent items folder into C:\Users\folder Topic is solved

Thanks both for your final answers, they both worked. I've chosen FanaticGuru answer because it got exactly what i was looking for 1. the last investigation complete email 2. this time it actually copied over to the subfolder Xeo786 Thank you, your answer will definitely be useful in future scripts...
by JKnight_xbt33
29 Jan 2020, 06:50
Forum: Ask For Help
Topic: Copyng an email from sent items folder into C:\Users\folder Topic is solved
Replies: 11
Views: 533

Re: Copyng an email from sent items folder into C:\Users\folder Topic is solved

Thanks for both your scripts. I tried them and came across the following minor issues: 1. both scripts work but save the email one directory level up For example it will save the file in Documents rather than 18-reports PDFs C:\Users\JK\Documents\18-reports PDFs\ FYI I have shared network drive whic...
by JKnight_xbt33
28 Jan 2020, 05:55
Forum: Ask For Help
Topic: Copyng an email from sent items folder into C:\Users\folder Topic is solved
Replies: 11
Views: 533

Re: Copyng an email from sent items folder into C:\Users\folder Topic is solved

Thanks for your reply Xeo786 , I understand its untested. I tried your script with two different folders and nothing happened, no email was moved into these folders. Please note : I had to comment out the regex line because it said the \\ is an illegal character. Apart from that the only thing I can...
by JKnight_xbt33
27 Jan 2020, 09:17
Forum: Ask For Help
Topic: Copyng an email from sent items folder into C:\Users\folder Topic is solved
Replies: 11
Views: 533

Copyng an email from sent items folder into C:\Users\folder Topic is solved

Good afternoon all, Had a look at the forum and all the answers seem to relate to sending emails. what I am trying to do 1. Get a specific email from the sent items (investigation reports complete.msg) 2. Hit the shortcut and it will copy this into a folder in my c drive e.g. C:\Users\JK\finished re...

Go to advanced search