default file location in a file
 

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?

default file location in a file
 

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?

default file location in a file
 

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
--
if it all works without errors then where is the challange?


"Chris Smith" wrote:

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?