Need help with VBA code

Joined
Nov 30, 2009
Messages
1
Reaction score
0
I am trying to use a macro in excel to auto save a file but need to do it so that it saves it to a different computer on a local network below is what i have that will work as long as it is only on the one computer

Sub SvMe()


Application.DisplayAlerts = False
Dim newFile As String, fName As String
fName = Range("n6").Value & " " & Range("h5").Text

ChDir _
"\Documents and Settings\Deputy Chief\Desktop\Time Sheets"
ActiveWorkbook.SaveAs Filename:=fName
Application.DisplayAlerts = True
Application.Quit
End Sub


the file when acessing it over the network listed as \\Chief\Time Sheets

I have tried that but with no luck any help wpuld be greatly appreciated
 
Last edited:
Back
Top