I have a very simple macro that isn't cooperating with me. Below is the code:

' Macro1 Macro
' Macro recorded 9/3/2004 by
'

'
ChDir "L:\file name"
ActiveWorkbook.SaveAs Filename:= _
"L:\Completed Fermenter Batch Sheets\Ferm 1 Batch 136.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
End Sub


Whereas L:\ is the network drive. When this macro is ran, everything seems to go as planned except that the file isn't saved on the network drive, it is saved on the desktop!

Any help or suggestions would be greatly appreciated!