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(msoFileDialogFolderPicker) > .AllowMultiSelect = False > .Show > Sel_Fldr = .SelectedItems(1) > End With > MsgBox Sel_Fldr > End Sub > > > *Paul* > ----------------------------------------- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----------------------------------------- > > *From:* Dr. Schwartz <carste...@gmail.com <javascript:>> > *To:* excel-...@googlegroups.com <javascript:> > *Sent:* Tuesday, October 21, 2014 4:05 AM > *Subject:* $$Excel-Macros$$ How to assign userselected path to variable > > In Excel 2010 I was trying to use the GetSaveAsFilename to obtain path and > file name, but not save the file. My problem is that it does not work in a > folder with restricted access. In my example the user only has permission > to read and add and the GetSaveAsFilename appears to create a temporary > file in the process. > > So my question is, how can get the user to browse and select the > destination folder and assign the path to a variable without saving > anything (at this point)? Maybe also include the file name, but this I can > always get using an Input command. > > Really, all input is appreciated! > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros...@googlegroups.com <javascript:>. > To post to this group, send email to excel-...@googlegroups.com > <javascript:>. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > >
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
