Advertisement
Guest User

Select Folder VBA

a guest
Sep 29th, 2023
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub SeleccionarRuta()
  2.     Dim SelFolder As FileDialog
  3.     Dim Ruta As String
  4.     Set SelFolder = Application.FileDialog(msoFileDialogFolderPicker)
  5.     With SelFolder
  6.         .Title = "Select A Target Folder"
  7.         .AllowMultiSelect = False
  8.         If .Show <> -1 Then Exit Sub 'Cancel
  9.        Ruta = .SelectedItems(1) & "\"
  10.     End With
  11.     MsgBox "La ruta seleccionada es: " & Ruta
  12. End Sub
Tags: excel vba
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement