how to find find last file name and increment - XL2000
 

XL2000

Hi All,

I have a macro that uses a range for a filename and then saves the workbook
under that name.

What I want to do now:

1) locate the last file name in a particular folder
2) increment by +1 the numeric part of the file name (format is XXXX 9999
XXXXXXXXXXX - where X are letters and 9 is the numeric part)
3) Discard the 2nd text part
4) display the result in a cell so I can use the original saveAs macro with
it.

MTIA

DS