bobbybrown
Board Regular
- Joined
- Apr 17, 2015
- Messages
- 121
Hi all,
I'm building an invoice system here and I'm stuck on a part of it.
I have all my invoices stored in a folder with filenames like:
0001 Name
0002 Name
0003 Name
On my worksheet, I want to be able to run a macro when the master workbook opens that will search the invoice directory on my computer for files and return the number part of the filename on the last modified invoice, which in theory will always be the last one made.
Using this, I can then create the next sequencial number manually on the new invoice.
I've tried using auto increasing numbers in the past but its never really worked for me, when opening the workbook to change things in the past it has caused issued with my numbers, so I think this is the ideal way for me.
Is there a way to use the date last modified or application file search for this?
Thanks,
I'm building an invoice system here and I'm stuck on a part of it.
I have all my invoices stored in a folder with filenames like:
0001 Name
0002 Name
0003 Name
On my worksheet, I want to be able to run a macro when the master workbook opens that will search the invoice directory on my computer for files and return the number part of the filename on the last modified invoice, which in theory will always be the last one made.
Using this, I can then create the next sequencial number manually on the new invoice.
I've tried using auto increasing numbers in the past but its never really worked for me, when opening the workbook to change things in the past it has caused issued with my numbers, so I think this is the ideal way for me.
Is there a way to use the date last modified or application file search for this?
Thanks,
