Hugo, вот отрывок кода где происходит сохранение документа: [vba]Code
If (Target.Row = 5 And Target.Column = 10) Or (Target.Row = 7 And Target.Column = 3) Then
PathToSave = "C:\"
FolderName = "ФОТОДНЯ"
FellPathToSave = PathToSave & FolderName & "\"
Set phd = CreateObject("Scripting.FileSystemObject")
If Not phd.FolderExists(FellPathToSave) Then
phd.CreateFolder (FellPathToSave)
End If
If (ThisWorkbook.Name = Range("J5") & "." & Range("C7") & ".xls") And (ThisWorkbook.Path + "\" = FellPathToSave) Then
ThisWorkbook.Save
Else
ThisWorkbook.SaveAs FellPathToSave & Range("J5") & "." & Range("C7") & ".xls"
End If
'End If
End If
[/vba]