Hi guys !!! How are you ? I need the VBA code fore Hyperlink. I have big DB and I want integrate Hyperlink to column E ( Report Number ). All reports scanned and store on the server Example ( Z:\QM\04_Piping\03_Visual & NDE Request Report\VISUAL 201 - FIELD )
Also I have 2 notes about the process:
1) Report number can be changed after some time and I want avoid some miss clicking as I read on this forum they put some trigger as a double click to open the hyperlinked file.
2) All files in PDF format ( CON-PIP-12-F0001.pdf ) and sometimes I have duplicates which named as CON-PIP-12-F0001 (2).pdf can we put some trigger as an error or red marc as additional option if possible.
Also I have 2 notes about the process:
1) Report number can be changed after some time and I want avoid some miss clicking as I read on this forum they put some trigger as a double click to open the hyperlinked file.
2) All files in PDF format ( CON-PIP-12-F0001.pdf ) and sometimes I have duplicates which named as CON-PIP-12-F0001 (2).pdf can we put some trigger as an error or red marc as additional option if possible.
