Hi,

I want to move a fresh copy of a file to a server location every morning when someone clicks on a button. However, even though I have write access to the server, it semms to blocks VBA from being able to do that. I ran several tests and had no problem saving the file to anywhere I wanted on my computer but not the server.


I figure the best work around is to save it to someone's desktop and open the file in the background so they can drag it into the folder. The folder already exists so I just need to open it. Somehow I can't get Shell, ShellExecute, or WinExec to work!

I found the function that, as I understand it, that is needed for an subroutine to work:
Please Login or Register  to view this content.

I found a code and added my own test file location, but it doesn't work:
Please Login or Register  to view this content.
How do I get this set up so I can open the folder?

Thanks!