I need to pass a vbscript variable to a path name. So far, all my attempts have resulted in a literal result. How do I get the variable of lookname to replace "lookname" in the path?
lookname = Page1.Num1.value
MsgBox ("File name to find is " & lookname) 'this works so I know variable is good.
Set objFSO = CreateObject("Scripting.FileSystemObject")
If objFSO.FileExists("C:\Graphis\Diagrams\lookname.doc") Then