Search found 86 matches

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

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

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

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

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

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

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

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

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

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

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

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...
by JKnight_xbt33
25 Jan 2020, 04:56
Forum: Ask For Help
Topic: Combining loopreadline with filecopy into subfolders Topic is solved
Replies: 2
Views: 260

Re: Combining loopreadline with filecopy into subfolders Topic is solved

Thanks for your reply @TravisQ,

The script works perfectly and amazingly.

Thank you

:dance: :bravo:
by JKnight_xbt33
23 Jan 2020, 09:37
Forum: Ask For Help
Topic: Combining loopreadline with filecopy into subfolders Topic is solved
Replies: 2
Views: 260

Combining loopreadline with filecopy into subfolders Topic is solved

Hello again, I am tweaking a script which I got from https://www.autohotkey.com/boards/viewtopic.php?f=76&t=71180 Thanks flyingDman for your help with this script: After trying it nothing happens, the file is not moved to the subfolders. Perhaps I've overcooked it. goal of script Read ID numbers fro...
by JKnight_xbt33
17 Jan 2020, 09:05
Forum: Ask For Help
Topic: Sending %A_Index% values without hard-coding them into script Topic is solved
Replies: 3
Views: 329

Sending %A_Index% values without hard-coding them into script Topic is solved

Dear all, I made a script based on this thread: https://autohotkey.com/board/topic/80517-ahk-to-read-a-text-file-copy-first-linepaste-and-loop/ The idea is to read a txt file line by line, get the ID number in each line and create a pseudo array for each line. After that if I open a blank document a...
by JKnight_xbt33
17 Jan 2020, 08:43
Forum: Ask For Help
Topic: Move files to a subfolder sharing part of the file name Topic is solved
Replies: 3
Views: 473

Re: Move files to a subfolder sharing part of the file name Topic is solved

Thanks for this @flyingDman I'll bear this much simpler and easier to understand AHK code in mind for the next time.
:D
by JKnight_xbt33
08 Jan 2020, 12:53
Forum: Ask For Help
Topic: Move files to a subfolder sharing part of the file name Topic is solved
Replies: 3
Views: 473

Re: Move files to a subfolder sharing part of the file name Topic is solved

Got the answer to my question but I had to use a batch/cmd script from stack exchange. Its quite complicated to be honest but the person was kind enough to explain how it all works. See my thread for this in the stackoverflow link below: https://stackoverflow.com/questions/59546150/move-files-into-a...
by JKnight_xbt33
03 Jan 2020, 08:00
Forum: Ask For Help
Topic: Selecting 3rd item from a combobox in a programme
Replies: 1
Views: 292

Selecting 3rd item from a combobox in a programme

Hi All, I use a programme called Q-pulse. I want to select the 3rd drop down item Email from the drop-down which says source of complaint. dropdown 1.PNG dropdown 2.PNG I read up control command: https://www.autohotkey.com/docs/commands/Control.htm I also read up a thread suggestion: https://autohot...
by JKnight_xbt33
30 Dec 2019, 15:30
Forum: Ask For Help
Topic: Move files to a subfolder sharing part of the file name Topic is solved
Replies: 3
Views: 473

Move files to a subfolder sharing part of the file name Topic is solved

Dear Broskis & Broskas. I have a starting folder C:\Users\JK\Documents\reports PDFs . This contains pdf files e.g. 2223-report.pdf I have a destination folder W:\Departments\QA\cases containing sub folders, for example W:\Departments\QA\cases\2201 - 2300\2223 I want to move the PDFs from my starting...

Go to advanced search