How do I use VBA to sort a list of file paths in this order here?
Title Page, Daily Cash Deposit Log, Journal by Cashier and Transaction Code, Manager Report, New Trial Balance, Trial Balance, CC History , Night Audit CC Authorization, Credit Limit all payment types, Open Balances All, Market Code Statistics, Deposit Ledger, Rate Variance , Detailed Aging , A/R Settlement , Guest by Tax Type, Guest Trial Balance , Guest Ledger Detail, Guest Ledger, Cashier Audit, Guests in House Comp, Out of Order, Paid Outs, Adjustment Log
Here is an example of the file paths for the names listed above:
Im not sure how to get it to sort in the order needed as i cant use alphabetical like normal and it should always list in that order.
Any help would be great thank you
Title Page, Daily Cash Deposit Log, Journal by Cashier and Transaction Code, Manager Report, New Trial Balance, Trial Balance, CC History , Night Audit CC Authorization, Credit Limit all payment types, Open Balances All, Market Code Statistics, Deposit Ledger, Rate Variance , Detailed Aging , A/R Settlement , Guest by Tax Type, Guest Trial Balance , Guest Ledger Detail, Guest Ledger, Cashier Audit, Guests in House Comp, Out of Order, Paid Outs, Adjustment Log
Here is an example of the file paths for the names listed above:
C:\Users\Example\Desktop\02-16-2020\Adjustment Logtest.pdf |
C:\Users\Example\Desktop\02-16-2020\AR Settlement.pdf |
C:\Users\Example\Desktop\02-16-2020\Cashier Audit.pdf |
C:\Users\Example\Desktop\02-16-2020\Credit Card History.pdf |
C:\Users\Example\Desktop\02-16-2020\Credit Limit alltypes.pdf |
C:\Users\Example\Desktop\02-16-2020\Deposit Ledger.pdf |
C:\Users\Example\Desktop\02-16-2020\Detailed Aging.pdf |
C:\Users\Example\Desktop\02-16-2020\Guest by Tax.pdf |
C:\Users\Example\Desktop\02-16-2020\Guest COMP.pdf |
C:\Users\Example\Desktop\02-16-2020\Guest Ledger Detail.pdf |
C:\Users\Example\Desktop\02-16-2020\Guest Ledger.pdf |
C:\Users\Example\Desktop\02-16-2020\Guest Trial Balance.pdf |
C:\Users\Example\Desktop\02-16-2020\Journal by TRA.pdf |
C:\Users\Example\Desktop\02-16-2020\Manager Report.pdf |
C:\Users\Example\Desktop\02-16-2020\Market Code.pdf |
C:\Users\Example\Desktop\02-16-2020\New Trial Balance.pdf |
C:\Users\Example\Desktop\02-16-2020\Night Auth.pdf |
C:\Users\Example\Desktop\02-16-2020\Open Balance.pdf |
C:\Users\Example\Desktop\02-16-2020\Out of Order.pdf |
C:\Users\Example\Desktop\02-16-2020\Paid Out.pdf |
C:\Users\Example\Desktop\02-16-2020\Rate Variance.pdf |
C:\Users\Example\Desktop\02-16-2020\RM222.pdf |
C:\Users\Example\Desktop\02-16-2020\Title.pdf |
C:\Users\Example\Desktop\02-16-2020\Trial Balance.pdf |
Im not sure how to get it to sort in the order needed as i cant use alphabetical like normal and it should always list in that order.
Any help would be great thank you