A new problem comes up when the first argument of vLookup function is not in the table. e.g. if I put "2000" as the first argument for the above vLookup function, the error "type mismatch" comes up again. But in my opinion, the return value should be "#N/A" if there is no exact match. Prost, do...
What’s wrong with the VLookup function my following VBscript codes? The error remind me “type mismatch”.
function searchTimeById(OpId)
Dim objExcel, excelPath, strData,
Set objExcel = CreateObject("Excel.Application")
excelPath = "Z:\OpLibrary.xls"
objExcel.Workbooks.open...
The purpose of my program is to realize the expert reasoning through a sequence of dialogs interacting with a user. All the user inputs of reasoning procedure need to be recorded for future enquiry in a database. The architecture of the reasoning procedure is like a pyramid, from top to bottom...
