I asked a question earlier today on hyperlinks and it was answered. Now I am having trouble with the file extension. while -
strFullFileName = strJobPlansPath & strYear & "" & pubLngProposalNo & ".pdf"
FollowHyperlink strFullFileName
works well, I have different file extensions. I have tried -
strFullFileName = strJobPlansPath & strYear & "" & pubLngProposalNo & ".*"
FollowHyperlink strFullFileName
without any success. I have also tried -
strFullFileName = Dir(strJobPlansPath & strYear & "" & CStr(pubLngProposalNo) & ".*")
FollowHyperlink strFullFileName
without any success.
strJobPlansPath =" L:\aaTS\AAFilesToCopy\Job Plans"
strYear - "2023"
pubLngProposalNo = 20231532
Please help.