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
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: