Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Save Folder Location on Network
I have a code that prompts a user to save a file to a Network Location.
Is there a way to ONLY allow a Specified Folder to on the Network to be the location the file can be saved? Or at least the User is given that folder option 1st? Preferably ONLY folder to save to. It will be a Print to PDF.Save File location line of code. Corey..... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Save Folder Location on Network
Without completely forcing a save of the file in your code, I don't believe
you can force a specific location for the save, they can always change it. If you want to give them the option to save in a specific location, add this line ChDir ("C:\Documents and Settings\barbara.reinhardt\Desktop\Temp") (change to suit.) -- HTH, Barb Reinhardt "corey" wrote: I have a code that prompts a user to save a file to a Network Location. Is there a way to ONLY allow a Specified Folder to on the Network to be the location the file can be saved? Or at least the User is given that folder option 1st? Preferably ONLY folder to save to. It will be a Print to PDF.Save File location line of code. Corey..... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Save Folder Location on Network
Thanks
"Barb Reinhardt" wrote in message ... Without completely forcing a save of the file in your code, I don't believe you can force a specific location for the save, they can always change it. If you want to give them the option to save in a specific location, add this line ChDir ("C:\Documents and Settings\barbara.reinhardt\Desktop\Temp") (change to suit.) -- HTH, Barb Reinhardt "corey" wrote: I have a code that prompts a user to save a file to a Network Location. Is there a way to ONLY allow a Specified Folder to on the Network to be the location the file can be saved? Or at least the User is given that folder option 1st? Preferably ONLY folder to save to. It will be a Print to PDF.Save File location line of code. Corey..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
default save location on network | Excel Discussion (Misc queries) | |||
Force a Readonly Workbook to save to a different folder | Excel Discussion (Misc queries) | |||
Cannot save excel files to a folder on a network | Excel Discussion (Misc queries) | |||
Unable to save file to Windows 98 network folder | Excel Discussion (Misc queries) |