Hi

I have a link which i have to update the weeknumber (wk01,02etc) of on
a weekly basis i.e.
s:\sitelabour\reports2008\variances\wk01...

I want to make this as foolproof as possiuble for people to do. Is
there a macro button that will do this by asking people to put in the
week number i.e 01 which will then update links.

Is there also anyway of displaying on a sheet the current link so
people can see what week number they are using?

Much Appreciated

Brian