I'm trying to come up with a routine that allows a user to browse to a file and then copy it to the same path as the active workbook - this is what I have so far;
Dim SourceFile, DestinationFile
SourceFile = Application.GetOpenFilename(FileFilter:="PDF Files (*.pdf), *.pdf", Title:="Select...