Reading link in VBA?

  • Thread starter Thread starter Don Wiss
  • Start date Start date
D

Don Wiss

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).
 
That's probably as quick as any method.
Click to expand...

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