A family of Microsoft relational database management systems designed for ease of use.
Never mind, made it work with the following:
Dim vFile As String
With Application.FileDialog(msoFileDialogFolderPicker) 'open Dialog box to select where to save files
.Title = "Select Folder to Export"
If .Show Then
vFile = .SelectedItems(1) & ""
End If
End With
'more code here
With xlBook
.SaveAs FileName:=vFile & FacName