Sub ПДФ()
Dim iNm, aNm
Application.ScreenUpdating = False
On Error Resume Next
With Worksheets("Протокол_неразр_28")
aNm = .Range("BA6").Value
iNm = .Range("BA5").Value
MkDir "C:\Users\I_YES\Desktop\" & aNm & "\" & iNm
.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:="C:\Users\I_YES\Desktop\" & aNm & "\" & iNm & "\" & iNm & ".pdf", _
OpenAfterPublish:=False
End With
Application.ScreenUpdating = True
End Sub
Спасибо большое за помощь....
Dim iNm, aNm
Application.ScreenUpdating = False
On Error Resume Next
With Worksheets("Протокол_неразр_28")
aNm = .Range("BA6").Value
iNm = .Range("BA5").Value
MkDir "C:\Users\I_YES\Desktop\" & aNm & "\" & iNm
.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:="C:\Users\I_YES\Desktop\" & aNm & "\" & iNm & "\" & iNm & ".pdf", _
OpenAfterPublish:=False
End With
Application.ScreenUpdating = True
End Sub
Спасибо большое за помощь....