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 creating and writing data to the file temporarily on the c-drive and moves it to the restricted folder in the end. It is the last move that requires that the user input path and file name.
I still wonder why GetSaveAsFilename creates a temporary file??? - Doc Den tirsdag den 21. oktober 2014 14.26.32 UTC+2 skrev Paul Schreiner: > > 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 you can do with Application.FileDialog(msoFileDialogFilePicker) > > *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.
