Relative Content

Tag Archive for excelvbafile

Comparing cell values in files with identical names

I have a process that exports two sets of identical Excel files – a first set where users can edit data and a second reference set that enables file compare to identify edits made in the first set. Each file has only one sheet and the file name is the sheet name plus _YYYYMMDD and extension (14 characters).