txt file on network drive

[NurseIS]

Have a small form which can write to a local file. I'd like to place the html form on a share drive and have the appendable txt file there also. Using client PC only; no web server.

I've adjusted the file path part of the script but it does not write to the file which is also in the same folder as the html file on the share drive. Will vbs write to files on the network or am I spinning my wheels?

I've also tried with the UNC path (abbreviated here) -- \\...fpc1\share\....

Ex:
Set fso=CreateObject("Scripting.FileSystemObject&quot
Set ts = fspenTextFile("S:\NIS_staffshare\FdBk\bcmaLog.txt", ForAppending, False)
ts.WriteLine(strNdate & "^^" & strLoc & "^^" & strComment & "^^" & strUsername & "^^" & strUserTel)
ts.Close

(Makes a delimited text file.)


Any pointers?

Thank you.

 

[FengShui1998]

NurseIS,

You should be able to open and write to the file as long as you have permissions.

On error Resume Next
Set ts = fspenTextFile("S:\NIS_staffshare\FdBk\bcmaLog.txt", ForAppending, False)
If err.number <> 0 then
msgbox err.number & &quot; &quot; & err.description
End if

Try this. It should tell you what the problem is.

fengshui_1998

 

[NurseIS]

returns &quot;424 object required&quot;
I'll see if I can find the error listing in the books. Thanks!!!

 

[NurseIS]

Of course the error was found - but what to do about it ??? What object has to be declared when addressing a network drive path? The script works fine for a local path.

Thanks again.

 

[jonscott8]

First, the FSO makes no differentiation if the drive is local or network (mapped drive or unc).

The fact that you state it works for a local path, but not a mapped drive or UNC path, screams permission-issue, as FengShui1998 eluded. Check both share permissions and file permissions(ntfs).

Also, FengShui1998 omitted initializing the fso variable in the snippet above, if you also omitted it, you would get the &quot;424 object required&quot;.

Jon Hawkins

 

[NurseIS]

OK. Thought I'd checked permissions but will do. Thank you!