On Sat, 9 May 2009 22:25:01 -0700, FSt1
wrote:

hi
what version of excel do you have??
2003 on the menu bar.....
toolsoptionsgeneral tabdefault file location:
enter the file path to your default file folder.
2007
office buttonexcel options not sure after here but it's there somewhere.

Regards
FSt1
Many thanks - Excel 2003 - your suggestion was exactly what was needed