Excellent! works like a treat.. thanks very much pascal. your help  is
much appreciated.Thank god for people like you life is much easier
for the rest of us!!!!

You are right the primary objective was to put the workbook's name in
the specific  cell!But then i also wanted to try inserting a list into
specific files...