That's probably as quick as any method.

--
Regards,
Tom Ogilvy


"Don Wiss" wrote in message
...
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).