Open attachements based on start date end date

Topic

New Reply

Dear Gurus,

I need calendar control in first column start dates and second column end date (end date fixed by user) third column The names ,fourth column PDF files extensions and fifth videos extention.

I have many PDF files and videos in one folder in folder the file names and video names contains date and name. What I want When I click to The name and select start date and click to 4th column it open for me the same date pdf and for video when I click to 5th column selecting dates open for me video.

For column third last pdf or video file of datetime stamp appears by selecting the Name ?

hope I ask well…

Reply | Quote

Replies

There is a date picker you can use in XL2010 (http://www.fontstuff.com/excel/exltut03.htm) or Walkenbach as some for XL2003-2010 and one for XL2013 (http://www.rondebruin.nl/win/addins/datepicker.htm).

To link to a file you could use the HYPERLINK function, based on the path and name created by the row. The exact formula will depend on your setup and the format of the date in the name. Could you provide an example file with the pathnames?

Steve

Reply | Quote

Sir,
Please find attached the sample excel file please.

Reply | Quote

Farrukh

The following code shows how open a calendar when you click in columns 2 to 3. When you select the date, it will place it in the active cell. Modify the code to suit your needs

36535-DTPicker

Sheet1 Module:

Code:

Dim rng As Range

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 If Target.Cells.Count > 1 Then Exit Sub
    If Not Intersect(Target, ActiveSheet.Columns(2)) Is Nothing Or _
        Not Intersect(Target, ActiveSheet.Columns(3)) Is Nothing Then
        Set rng = Target
        Calendar.Show
    Else:
        Calendar.Hide
    End If
End Sub

Calendar Form:

Code:

Private Sub DTPicker1_Change()
    ActiveCell.Value = DTPicker1.Value
    Calendar.Hide
End Sub

HTH,
Maud

Reply | Quote