Using vba how do I open a file if I dont know what it is saved as?
It can be a pdf jpeg doc or xls
This is what I use to open a pdf
Thank you in advance
It can be a pdf jpeg doc or xls
This is what I use to open a pdf
Code:
myfile = "U:\Personnel Records\Training\" & Cells(1, ActiveCell.Column).Value & "\" & Format(Cells(ActiveCell.Row, 1).Value, "0000") & ".pdf"
ActiveWorkbook.FollowHyperlink Address:=myfile, NewWindow:=True, AddHistory:=True
Thank you in advance