Input filename to worksheet?

[zakynthos]

Is there a way that I could automate the input of the name of the worksheet file to the worksheet itself, say in location AZ1, when the worksheet is opened?

I've renamed 200 email attachments with a code representing the team member that would deal with that atatchment and have included the current date and time - for example:

TM1.1 270711 13:11 1.xls to TM10.20 270711 13:11 20.xls

and it is this range that I want to attach to each of the respective attachments to which it relates in AZ1, as the file is opened.

many thanks

 

[villy]

maybe...

Range("AZ1").value= whatever the filename

 

[zakynthos]

Perfect!- thanks for such a quick response

 

[villy]

Perfect!- thanks for such a quick response

You are most welcome...