e you can,
As long as ever you can.” - John Wesley
-
>
> From: Dr. Schwartz
>To: excel-macros@googlegroups.com
>Cc: schreiner_p...@att.net
>Sent: Wednesday, October 22, 2014 2:57 AM
>Subject: Re: $$Excel-Macros$$ How to assign u
Hi Paul, please excuse my poor description. Let me try and elaborate.
The folder in question is set up so the user can have either write (create
and modify files) or or add (only create files) permission. My users only
have the add permission. For the same reason the application is actually
cre
Thank you Paul, works perfect as a workaround!
Den tirsdag den 21. oktober 2014 14.10.32 UTC+2 skrev Paul Schreiner:
>
> You can use the FileDialog method with msgFileDialogFolderPicker:
>
> Sub Select_Folder()
> Dim Sel_Fldr As String
> With Application.FileDialog(msoFileDialogFolderPic
Just out of curiosity...
If the user doesn't have write permission to the folder,
why would you want to get a SaveAs filename?
Wouldn't they have a problem later when they need to save?
Or are you really only trying to pick a file name from the folder
and have no intention of saving?
which yo
You can use the FileDialog method with msgFileDialogFolderPicker:
Sub Select_Folder()
Dim Sel_Fldr As String
With Application.FileDialog(msoFileDialogFolderPicker)
.AllowMultiSelect = False
.Show
Sel_Fldr = .SelectedItems(1)
End With
MsgBox Sel_Fldr
End Sub
