DaveBlakeMAAT
Board Regular
- Joined
- Feb 28, 2016
- Messages
- 190
Hi
I am having a bit of a brain fart on this particular problem when it comes to ordering my loops correctly. I have a folder of scanned invoices (file names are sequentially numbered), I also have a spreadsheet which contains the invoice numbers in column A and a Page Count in Column B (one invoice can have multiple scanned image files.
I am fine with using Scripting Runtime and looping through each file in the nominated folder. Where I am struggling is getting my loops in the correct order!
My objective is to rename the files so that they are prefixed with the invoice number and suffixed with Page "x".
Any pointers in the right direction would be very much appreciated!
Regards
Dave
I am having a bit of a brain fart on this particular problem when it comes to ordering my loops correctly. I have a folder of scanned invoices (file names are sequentially numbered), I also have a spreadsheet which contains the invoice numbers in column A and a Page Count in Column B (one invoice can have multiple scanned image files.
I am fine with using Scripting Runtime and looping through each file in the nominated folder. Where I am struggling is getting my loops in the correct order!
My objective is to rename the files so that they are prefixed with the invoice number and suffixed with Page "x".
Any pointers in the right direction would be very much appreciated!
Regards
Dave