Access To Excel Link To File

[DMT Dave]

Hi Guy's is there a way i can add a link to an excel cell and call each cell within the recordset range ie: if there is 43 items to output, the first 2 rows are header there for cells 3 to 46 (43 records) and have this a link to a file based on 2 of the data from other cells?

The file names are all named by a date formated 00-00-00 Dealer Name.pdf each dealer name has their specific folder so the path would be ie:

T:\MyCustomer\PDF\POD's\

The Date and Dealer Name are already on the output as follows

All of the strings and all is set and works so rather than add loads of code:



I could do with the recordset adjusting to link to a file based on cell(3 ,3) DeliveryDate and Cell (3 ,4) Dealer Name file is called 19-01-19 Joe Bloggs

Click View POD and it opens that file name ??

Current rs

Set rs6 = CurrentDb.OpenRecordset("SELECTtblAssign.DeliveryD ate, tblAssign.DelTo, tblAssign.Town, tblAssign.SONumber,tblAssign.PONumber, tblAssign.LiftType, tblAssign.LiftNo, tblAssign.Status FROMtblAssign WHERE Customer = '" & Cust & "'" & "And Source = '" & Src & "'" & " ORDER BYDeliveryDate DESC")

.Worksheets(6).Cells(3, 3).CopyFromRecordset rs6

Ideal result

[CJ_London]

not clear if you are reading excel from access or access from excel. If the former you can use a query

per another thread I've just responded to https://www.accessforums.net/showthread.php?t=77811

shame you are not consistent with date formats so you would have to convert 'Jan' to '01'