Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have a set of Excel files sitting on a shared network drive which can only be accessed through a file managing system developed with MS Access. The users need the ability to save a copy of the file on their desktop. I did it by using following code and it works fine. Set WshShell = CreateObject("WScript.Shell") ThisWorkbook.SaveAs Filename:=WshShell.SpecialFolders("Desktop") & "\" & ThisWorkbook.Name, password:="" But our Information System department decided to execute the MS Access file manager through a Citrix server. Everything else works fine, but automatically saving of the copy on the user's desktop. I know this is something to do with the file path through the Citrix server, however, I don't know a method to get set the path automatically to the users desktop and save a copy there. Can anyone help me with this? Thank you in advance Toyfixer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up a file to automatically save on exit? | Excel Discussion (Misc queries) | |||
Macro - Save file in Desktop | Excel Worksheet Functions | |||
Automatically save a file in another directory | Excel Discussion (Misc queries) | |||
Save web page as desktop file from Excel/VBA | Excel Programming |