Thanks to Skip and Andy for helping me construct a VBA which grabs .txt data and pastes it into a single spreadsheet.
Invoice File
There are three companies and all of which have different filename for their .pdf invoice file.
When pasting the .txt data:
D01CC96625668 +0000004632409201821172698 Payment to Ross & Robs
Macro splits up the info in the following:
CC96625668 463 24/09/2018 21172698 Payment to Ross & Robs BAILIFFROSSANDROB01102018.txt Link
Company One
Based on the CC number, is it possible to find a .pdf file with that number within the same months' folder that the .txt file is held?
Folder structure for that .pdf file:
2018 > 10 October > Ross and Robs > 02 10 2018 LBCSBI > Successful
The second company's .pdf filename does not include the CC identifier. An example of the filename is SuccessfulDetail_ followed by five numbers.
Folder structure for that .pdf file:
2018 > 07 July > JBW > 18 07 2018 > Successful
The third company's .pdf filename also does not include the CC identifier. An example of the file is London Borough of Croydon_RT Croydon_ followed by five-six numbers.
Folder structure for that .pdf file:
2018 > 03 March > Whyte > 09 03 2018 02 > Successful
Sometimes there can be zero .pdf files in that folder.
Remit Files
Alongside this, I wish to input the directory of a remit file which just sits within:
2018 > 10 October > Ross and Robs > 02 10 2018 LBCSBI
2018 > 07 July > JWB > 18 07 2018
2018 > 03 March > Whyte > 09 03 2018 02
First company's .pdf filename example:
ClientRequestDetail_ followed by five numbers.
Second company's .pdf filename example:
London Borough of Croydon_RT Croydon_Payment_Advice_ followed by five-six numbers.
Third company's .pdf filename example:
Remit- followed by five numbers.
I hope this makes sense. A lot of the .pdf files will be repeating themselves (for companies two and three).
Thank you in advance.
Invoice File
There are three companies and all of which have different filename for their .pdf invoice file.
When pasting the .txt data:
D01CC96625668 +0000004632409201821172698 Payment to Ross & Robs
Macro splits up the info in the following:
CC96625668 463 24/09/2018 21172698 Payment to Ross & Robs BAILIFFROSSANDROB01102018.txt Link
Company One
Based on the CC number, is it possible to find a .pdf file with that number within the same months' folder that the .txt file is held?
Folder structure for that .pdf file:
2018 > 10 October > Ross and Robs > 02 10 2018 LBCSBI > Successful
The second company's .pdf filename does not include the CC identifier. An example of the filename is SuccessfulDetail_ followed by five numbers.
Folder structure for that .pdf file:
2018 > 07 July > JBW > 18 07 2018 > Successful
The third company's .pdf filename also does not include the CC identifier. An example of the file is London Borough of Croydon_RT Croydon_ followed by five-six numbers.
Folder structure for that .pdf file:
2018 > 03 March > Whyte > 09 03 2018 02 > Successful
Sometimes there can be zero .pdf files in that folder.
Remit Files
Alongside this, I wish to input the directory of a remit file which just sits within:
2018 > 10 October > Ross and Robs > 02 10 2018 LBCSBI
2018 > 07 July > JWB > 18 07 2018
2018 > 03 March > Whyte > 09 03 2018 02
First company's .pdf filename example:
ClientRequestDetail_ followed by five numbers.
Second company's .pdf filename example:
London Borough of Croydon_RT Croydon_Payment_Advice_ followed by five-six numbers.
Third company's .pdf filename example:
Remit- followed by five numbers.
I hope this makes sense. A lot of the .pdf files will be repeating themselves (for companies two and three).
Thank you in advance.