I have a project to open a few hundred workbooks, run a macro that makes
changes, and then save them. In the same folders are other workbooks that
are not to be updated. To not have to open the unwanted workbooks the macro
is putting into a worksheet cell a link to a range in the workbooks with
the version. Then a Range("xx").Value = Range("xx").Value on that cell
turns the string into a linked value. Then if it passes IsError, I read the
version and decide whether it is one I want to process. This works fine,
but I was wondering if VBA could do all of it without using a worksheet
cell.

Don <www.donwiss.com (e-mail link at home page bottom).