Here is my code;
If FSObj.FileExists("\\sfile0\e\cnc\vm2\" & Forms!frmHurcoSetups.ProgNum & "*" & ".HD3") Then
MsgBox "The application was unable to locate a program for this tool sheet. " & _
"You will need to manually move the program from the Server to the unproven folder. " & _
"Be sure the Tool Sheet # does not have the revision or hd3 in the name before closing the Tool Sheet back out."
Basically the filename I'm trying to get it to match is 006.hd3
I want it to beable to match it using Forms!frmHurcoSetups.ProgNum which is 006 and a wildcard which in this case will be nothing, and ".hd3".
It's not finding the filename with my code setup the way it is though.
Anyone got any ideas as to how I can tweak this so that it will find the file?