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 cre

Re: $$Excel-Macros$$ How to assign userselected path to variable

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

$$Excel-Macros$$ Write X,Y,Z Data

Hello MS EXCEL AND VBA MACROS member. Could you help me? So, i have data excel, this is the picture : Unfill cells is the Z value But, I want to write it in to another sheet but in differ

Re: $$Excel-Macros$$ How to assign userselected path to variable

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

Re: $$Excel-Macros$$ Re: Pasting Data from Different Files in One Worksheet

cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Oct 21, 2014 at 5:08 PM, Hasnain Raja wrote: > Thanks guys for your help actually I was able to fix my code with line > from Vabz. > > I wasn't able to open the file sent due to firewall at my company bu

Re: $$Excel-Macros$$ How to assign userselected path to variable

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

$$Excel-Macros$$ Re: Pasting Data from Different Files in One Worksheet

Thanks guys for your help actually I was able to fix my code with line from Vabz. I wasn't able to open the file sent due to firewall at my company but anyways much 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 Fa

$$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