Macro/VBA Beginner-HELP!!

[ryspags]

Hey Everyone:

I am an absolute beginner at macro and vba but I want to learn because it will make my job that much easier. Can someone help me with creating this macro...

I currently have an excel document with links to other excel files. This allows my colleagues to click on the link of the file they want to view. However, these file names change frequently which makes the path invald. Is there a macro or some way to prevent this? Basically so I do not have to constantly keep updating the file paths.

thank you in advanced!

[Bob Phillips]

Guess what, you have the problem with linking files. That is why most of us avoid linking.