Hi I have the same issue and I followed your instructions and created a virtual folder under the main website and i can see the content of the folder in IIS but i am not able to connect via asp script , could you please suggest i am getting below error message :
Microsoft VBScript runtime error '800a004c'
Path not found
/xyz/Addxls_auto.asp, line 111
My Code is below :
Code:
foldername=CStr(cyear) & mm & dd
Set objFolder = objFSO.GetFolder(Server.MapPath("myfolder"))
mPathName = "myfolder\"&foldername&"\"&"subdirectory"&"\"&"temp.xls"
' Response.Write mPathName & "<br>"
'-- Start of First Record Entry ------------------
If (fs.FileExists(mpathName)) = true Then
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"Dbq=" & mpathName & ";" & _
"DefaultDir=B:\temp"