default file location in a file

[Guest]

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,

 

[Guest]

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

Chris

 

[Guest]

The problem is that I only have a link to an xlt file somewhere on the
server. When the user clicks it, excel wil pop open as an excel spreadsheet.
I've seen in the sharepoint sdk that a certain activeX component is used to
open an excel file and the default save directory is given with it; therefore
a certain syntax must exist of how the file is opened with a default save
directory...

anyone?
thx