Re: $$Excel-Macros$$ Hyperlink Cells to Files with Only Half the File Name

2013-12-26 Thread ashish koul
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

Re: $$Excel-Macros$$ Hyperlink Cells to Files with Only Half the File Name

2013-12-26 Thread ashish koul
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

$$Excel-Macros$$ Hyperlink Cells to Files with Only Half the File Name

2013-12-26 Thread Dov Abrams
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