Generate file hyperlink based on concatenated Cells.

Sorry if I worded the title wrong. Let me explain

My spread sheet is set up like this

_____A_______________B_______________C_________________D
1 File Path________Vendor Name_____Invoice Date_______Invoice Number
2 =B&C____________MASSY__________1/31/2022__________1234
3 =B&C__________PIZZA HUT________1/29/2022___________6549

My excel sheet is in the same folder as pdfs of each invoice and each invoice has the name format "B&C" like MASSY1234.pdf and PIZZA HUT6549.pdf.

Is it possible to have A2 return the a hyperlinked path for the file so the user can click it and it opens up?

I know that you can go to manually do it with Insert-->Link and browse for the location but can this be automated?

Just add ELSE and then what you want it to do

Public Sub CreateHypersFromCells()
Dim vFile, vName, vVendor, vDate, vInvoice
Const kDIR = "c:\temp\"

Range("A2").Select
While ActiveCell.Offset(0, 1).Value <> ""
   
      'use path in cell to create hyperlink
   vVendor = ActiveCell.Offset(0, 1).Value
   vInvoice = ActiveCell.Offset(0, 3).Value
   
   vFile = kDIR & vVendor & vInvoice & ".pdf"
   
   'If FileExists(vFile) Then
      ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=vFile, TextToDisplay:=vFile
   'ELSE
     ' SPECIFY HERE WHAT YOU WANT IT TO DO
   'End If
   
   ActiveCell.Offset(1, 0).Select  'next row
Wend

End Sub