Sub choose_folder()
Dim fldname As String
Dim fd As FileDialog, fl As Variant
Set fd = Application.FileDialog(msoFileDialogFolderPicker)
With fd
.AllowMultiSelect = False
.Title = "Please select the folder"
.Show
End With
For
have you already added the file path or names in cells . Can you share
sample file ?
On Thu, Dec 26, 2013 at 1:56 PM, Dov Abrams wrote:
> Hi Folks,
> I need to hyperlink each cell in column D to a associated pdf file.
> However the name in the cell has only a part of the name of the associated
Hi Folks,
I need to hyperlink each cell in column D to a associated pdf file.
However the name in the cell has only a part of the name of the associated
file.
For instance, the name of the meeting minutes file is abc-123-2013.
However the name in the cell is abc, without the 123 or 2013 (abc is a