nniedzielski
Well-known Member
- Joined
- Jan 8, 2016
- Messages
- 590
- Office Version
- 2019
- Platform
- Windows
I am working with a macro that opens a file, pulls rows out and puts them into a workbook (wb). I am stuck on what to do when i want to save the workbook, how can i have the user set the destination for where to save the workbook when done? right now, I use this to tell them where to get the workbooks to get the data from: I assume the process is similar, i just dont know how to connect the dots
VBA Code:
Set FldrPicker = Application.FileDialog(msoFileDialogFolderPicker)
With FldrPicker
.Title = "Select A Target Folder"
.AllowMultiSelect = False
If .Show <> -1 Then GoTo NextCode
myPath = .SelectedItems(1) & "\"
End With