Reading link in VBA?
 

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).

Reading link in VBA?
 

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).

Reading link in VBA?
 

On Sun, 29 May 2005 17:35:43 -0400, Tom Ogilvy wrote:

Don Wiss wrote:
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.

That's probably as quick as any method.

That is what I expected. One reason for posting here is to disseminate the
idea amongst the group. There is one problem with it. When you open a
workbook you can add UpdateLinks:=0. But in the above I haven't seen a way
to say don't update, so if you come to one it stops and waits for a user
reply. It would, of course, be better it one could automatically answer the
question.

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