Are you looking for a macro which will find the workbooks as well as create
the hyperlinks. If so, are all the workbooks in a folder and subfolders off
that main folder?

Regards,

OssieMac

"GBrown" wrote:

I've got a large list of files in multiple folders that I want to hyperlink
and I don't want to do them one by one. How can I automate this using a macro?