Every day I run a macro.
Every day the macro leaves open a source file (it copies info into a new workbook).
I can't reliably close the source file within the Macro because the source file has a naming format like
VendorBacklog4343242343 (the numbers aren't a date or anything I can predict). Today's was 82435386 - which I hoped might be Unix time, but this is 1972 in Unix time.
Anyway I can refer to the file as "filebeginning(VendorBacklog).close" or some such?
THANKS