You are reading a single comment by @aggi and its replies. Click here to read the full conversation.
  • Cheers, used to running them but can only decode about a third of that so couldn't understand how the path was specified. Will give it a go shortly.

  • With Application.FileDialog(msoFileDialogFold­erPicker)
        .Show
        Pathname = .SelectedItems(1) & "\"
    End With
    

    Specifies the path. It's a nice bit of code for inserting in any macro where you want a path.

About

Avatar for aggi @aggi started