Consulting

Results 1 to 4 of 4

Thread: VBA Browse multiple workbooks how to short the code....

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    VBA Browse multiple workbooks how to short the code....

    Hi Team,
    
    
    I need your help plz assist, I am using below code to browse Multiple required Inputworkbooks, 
    is there a way to shorten this code, by creating single function.
    
    
    Thanks in Advance !
    
    
    Sub GetWorkbook1()
    Set myfile = Application.FileDialog(msoFileDialogOpen)
    With myfile
    .Title = "Choose File"
    .AllowMultiSelect = False
    If .Show <> -1 Then
    Exit Sub
    End If
    FileSelected = .SelectedItems(1)
    End With
    
    
    ActiveSheet.Range("b4") = FileSelected
    End Sub
    
    
    Regards,
    mg
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •