Odd, I don't think I've seen "Add" as an option for folder permissions. I can see having Create/write permission to the folder and all existing content is read-only so that it cannot be overwritten, but I don't recall seeing "Add". as for why GetSaveAsFileName is creating a file, I suspect that Microsoft was saving themselves some programming. In order to accomplish the GetSaveAsFileName, you'd need to verify the user's Windows Active Directory group memberships, verify the folder permissions by AD group, look for a combination that allows write access, then check the characters in the proposed filename to ensure that they are legal characters, and that the file doesn't already exist. Or, you can attempt to create a file of the designated name and designated folder and let the Windows OS do all the verifications and return a success/fail result.
I suspect that the VBA programmers went with the latter. 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 <carsten.in...@gmail.com> >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 userselected path to variable > > > >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> >>>To: excel-...@googlegroups.com >>>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. >>>To post to this group, send email to excel-...@googlegroups.com. >>> >>> >>> >>> >>>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. > > > -- 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.
