Hi All,

I am trying to create a text file containing the current data / time
and store it in the same folder as my workbook.

I am using the following code under Excel 2000 running under Win2000
Pro on a Win2000 Server domain:


Sub TimeCheck()

ShellCommand = "Net time " & ThisWorkbook.Path & "\_Time.txt"

MsgBox Shell(ShellCommand)

End Sub


The value returned in the MsgBox is obviously the program's task ID
(as expected), but the text file (time.txt) is not created in the
folder with the workbook.

There is no permissions issue - it won't work on a network drive nor
my hard disk where I have full permissions.


Any ideas?

Thanks,

Alan.