View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Heera Chavan[_2_] Heera Chavan[_2_] is offline
external usenet poster
 
Posts: 18
Default Save a file on a particular location Forcefully.

Hi all,

I have writen a macro to share and unshare workbook but some time the macro
save the file in my document folder instead of shared folder.

I want a macro(code) which will forcefully saves the workbook on shared
folder. I mean when ever the user try's to use save-as option the defult path
should be of shared folder.

Please help.

Regards
Heera Chavan