I have a workbook that will gather data from many other workbooks via links.
the other workbooks will always be in the same folder as the workbook
processing the links but I will not know the path of that folder.

I am putting the links in the cells via code like:

Range("b3").Formula = "='[62881.xls]Sheet1'!$B$4"

There are thousands of these links and when I run the code as is, it wants
me to point to the file for each line. How can I set the path to always be
in the current folder, wherever that folder is located?

Thanks in advance for any help
Christy ;)