LinkBack URL
About LinkBacks
Using VBA, how do I allow users to save files to a specific network shared location? Not all users are mapped the same, so the path is not consistant. The network location has a share name (cdsBulletins)
VBA: Saving To A Network Shared Folder
Using VBA, how do I allow users to save files to a specific network shared location? Not all users are mapped the same, so the path is not consistant. The network location has a share name (cdsBulletins)
Last edited by dumbnut; 05-24-2010 at 03:42 PM.
If your source workbook is already saved to that location, you can use:
Please Login or Register to view this content.
to get the location.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Dave,
The workbooks would be saved by users to the shared folder location, but are not already there.
use a path such as
\\servername\share$\folder\filename.xls
and the file will saved to the server, without regard to which letter the drive is mapped, or not mapped
sportsguy
apologies, I realized that my concern doesn't fit this thread. original comment deleted.
Last edited by nugundam93; 06-24-2019 at 12:08 PM.
"All your Dakar are belong to Pajero" 11 Dakar Rally wins...7 straight since 2001.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks