ChDir 'G:\\archives'
ActiveWorkbook.SaveAs Filename:='monfichier.xls'
Sub Macro1()
With Application
.DefaultFilePath = 'g:\\archives'
End With
End Sub
Private Sub Workbook_Open()
Application.DefaultFilePath = 'g:\\archives'
End Sub
sub changerep()
Application.DefaultFilePath = 'g:\\archives'
End Sub