hi, 

when creating a new excel workbook from Sharepoint, 
is there a way to get the path where the document will get saved on ? 

in vba or .net (excel addin), it seems there is no way to find out the sharepoint path, before it gets saved. 

thanks in advance

bernd

Hi,

By default, when creating a new Office document in a SharePoint library, there will be an option to enable users select a place to save the file, that means, the final file path is uncertain before it gets saved.

I suggest you provide more details about your complete requirement to see if there is any existing solution can work for you.

Thanks

okay, i try to give more details. 

1) sharepoint - > create new excel workbook 

2) excel opens with a new workbook. 

3) When i press save, the save as dialog opens with the sharepoint folder where i created the file

4) i need to know the path, before the user saves the file (WorkbookBeforeSave Event) in vba or .net (through excel addin)

i can't find any way to find out, the excel application object model seems to not have this information (application.defaultpath, workbook.path, ... )

thanks 

bernd

p.s.: in word i found 2 solutions: 1) a template is open where i can read the path
2) word gets opend with a commandline argument where i can extract the path

• Edited by berndniph09 19 minutes ago

okay, i try to give more details. 

1) sharepoint - > create new excel workbook 

2) excel opens with a new workbook. 

3) When i press save, the save as dialog opens with the sharepoint folder where i created the file

4) i need to know the path, before the user saves the file (WorkbookBeforeSave Event) in vba or .net (through excel addin)

i can't find any way to find out, the excel application object model seems to not have this information (application.defaultpath, workbook.path, ... )

thanks 

bernd

p.s.: in word i found 2 solutions: 1) a template is open where i can read the path
2) word gets opend with a commandline argument where i can extract the path

• Edited by berndniph09 27 minutes ago