I was wondering if the 'ActiveWorkbook.Path' property is what you are after...

Chris

"Philippe" wrote:

Hi,

I've got an excel 2003 template, when users open this file, I'd would like
the users to save it to a location specific for that document. So I couldn't
just let them all change the default location of excel...

Isn't there a magic trick for this, I mean, if you open a template from a
sharepoint lib, it always let you save it in the lib where it is opened from,
doesn't sharepoint give a parameter for default location with the doc when it
opens Excel? Because, then I could give the path to the location of the
folder....

thanks,
--
if it all works without errors then where is the challange?