Excel data linked to external source

[Doug Needham]

I have an Excel file with a large number of records (rows). Each row will be linked to a separate external source file.



I'm trying to setup a macro that will quickly create and change the external path for each row of data. All of the rows in my Excel file are consistent with the only difference being their source file. And the external source files are all similar to one another. So the only thing that's changing is the path. Is there an easy solution to this problem?

[macropod]

If you changed your formulae to use the INDIRECT function, you could store the path in a single cell, then change just that cell as/when needed. No macros required. Other than that, a simple Find/Replace should suffice. Again, no macros required.