Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default File location | Excel Programming | |||
Default file location | Excel Discussion (Misc queries) | |||
Default file location | Setting up and Configuration of Excel | |||
default file location | Excel Discussion (Misc queries) | |||
Default File Location | Excel Programming |