Hi everyone,
I cannot open a pdf file starting a specific text. Could you please check below code?
--------------------------------------------------------
file="123456ABC"
file = file & "*"
tgtfile = "\\filesrv\d\Serialproduction\" & file & ".pdf"
CreateObject("Shell.Application").Open (tgtfile) & vbNullString
------------------------------------------------------
"Serialproduction" folder consist of following files:
136547.pdf
123456ABC_RevA.pdf
896534L.pdf
896534E.pdf
----------------------------------------------------
I need to open a file starting with "123456ABC". That is all, but I cannot success it in Excel 2013 VBA.
I cannot open a pdf file starting a specific text. Could you please check below code?
--------------------------------------------------------
file="123456ABC"
file = file & "*"
tgtfile = "\\filesrv\d\Serialproduction\" & file & ".pdf"
CreateObject("Shell.Application").Open (tgtfile) & vbNullString
------------------------------------------------------
"Serialproduction" folder consist of following files:
136547.pdf
123456ABC_RevA.pdf
896534L.pdf
896534E.pdf
----------------------------------------------------
I need to open a file starting with "123456ABC". That is all, but I cannot success it in Excel 2013 VBA.