Дата/Элемент управления/Будущее

Sub add_date()
'
'Пример вычисления будущей даты
' This example takes a date and, using the DateAdd function,
' displays a corresponding date a specified number of months 
' in the future.
'
Dim FirstDate As Date    ' Declare variables.
Dim IntervalType As String ' "yyyy" Year, "q"  Quarter, "m"  Month,
'                       "y" Day of year, "d"   Day, "w"  Weekday "ww"  Week
Dim Number As Integer
Dim Msg
IntervalType = "m"    ' "m" specifies months as interval.
FirstDate = InputBox("Enter a date")
Number = InputBox("Enter number of months to add")
Msg = "New date: " & DateAdd(IntervalType, Number, FirstDate)
MsgBox Msg
End Sub

Sub FUTURE_DATE()
'
' FUTURE_DATE Макрос
'Вычисление будущей даты через определенное количество месяцев
'Значения начальной и вычисленной дат находятся в элементах управления "Календарь"
'с именами "начальная дата","конечная дата".
'Значение интервала дат находится в элементе управления "Текст" или "Форматированный текст"
'Элементы управления с указанными именами должны быть созданы в документе до начала работы макроса
Dim MyDate              ' Declare variables.
Dim s As String: Dim s1 As String: Dim s2 As String
s = "начальная дата"    '
s1 = "конечная дата"    '
s2 = "интервап"         '
Dim FirstDate As Date
Dim IntervalType As String
Dim Number As Integer
'
IntervalType = "m"    ' "m" specifies months as interval.
FirstDate = ActiveDocument.SelectContentControlsByTitle(s).Item(1).Range.Text
Number = ActiveDocument.SelectContentControlsByTitle(s2).Item(1).Range.Text
ActiveDocument.SelectContentControlsByTitle(s1).Item(1).Range.Text = DateAdd(IntervalType, Number, FirstDate)
'
End Sub

Sub FieldCodeToString()
'Автор: Graham Mayor - MS MVP (Word)
'Опубликовано на сайте  http://www.gmayor.com/export_field.htm
Dim oRng As Range
Dim Fieldstring As String
Dim NewString As String
Dim CurrChar As String
Dim CurrSetting As Boolean
Dim fcDisplay As Object
Dim MyData As DataObject
Dim X As Long
NewString = ""
Set fcDisplay = ActiveWindow.View
Application.ScreenUpdating = False
CurrSetting = fcDisplay.ShowFieldCodes
If CurrSetting <> True Then fcDisplay.ShowFieldCodes = True
Set oRng = Selection.Range
Fieldstring = oRng.Text
For X = 1 To Len(Fieldstring)
CurrChar = Mid(Fieldstring, X, 1)
Select Case CurrChar
Case Chr(19)
CurrChar = "{"
Case Chr(21)
CurrChar = "}"
Case Else
End Select
NewString = NewString + CurrChar
Next X
oRng.Text = NewString
Set MyData = New DataObject
MyData.SetText NewString
MyData.PutInClipboard
fcDisplay.ShowFieldCodes = CurrSetting
End Sub

Sub FieldStringToCode()
'Автор: Graham Mayor - MS MVP (Word)
'http://www.gmayor.com/export_field.htm

' Based on a macro provided by Paul Edstein
' Converts "textual" field codes into real field codes
' To do the conversion, simply paste the "textual" field codes
' into your document, select them and run the macro.
Dim RngFld As Range
Dim RngTmp As Range
Dim oFld As Field
Dim StrTmp As String
Dim sUpdate As String
Dim bFldCodes As Boolean
Const Msg1 = "Select the text to convert and try again."
Const Msg2 = "There are no field strings in the selected range."
Const Msg3 = "Unmatched field brace pairs in the selected range."
Const Title1 = "Error!"
Const Title2 = "Update fields?"
Application.ScreenUpdating = False
bFldCodes = ActiveDocument.ActiveWindow.View.ShowFieldCodes
If Selection.Type <> wdSelectionNormal Then
MsgBox Msg1, vbExclamation + vbOKOnly, Title1
Exit Sub
End If
If InStr(1, Selection.Text, "{") = 0 Or InStr(1, Selection.Text, "}") = 0 Then
MsgBox Msg2, vbCritical + vbOKOnly, Title1
End If
If Len(Replace(Selection.Text, "{", vbNullString)) <> Len(Replace(Selection.Text, "}", vbNullString)) Then
MsgBox Msg3, vbCritical + vbOKOnly, Title1
Exit Sub
End If
ActiveDocument.ActiveWindow.View.ShowFieldCodes = True
Set RngFld = Selection.Range
With RngFld
.End = .End + 1
Do While InStr(1, .Text, "{") > 0
Set RngTmp = ActiveDocument.Range(Start:=.Start + InStr(.Text, "{") - 1, End:=.Start + InStr(.Text, "}"))
With RngTmp
Do While Len(Replace(.Text, "{", vbNullString)) <> Len(Replace(.Text, "}", vbNullString))
.End = .End + 1
If .Characters.Last.Text <> "}" Then .MoveEndUntil cset:="}", Count:=Len(ActiveDocument.Range(.End, RngFld.End))
Loop
.Characters.First = vbNullString
.Characters.Last = vbNullString
StrTmp = .Text
Set oFld = ActiveDocument.Fields.Add(Range:=RngTmp, Type:=wdFieldEmpty, Text:="", PreserveFormatting:=False)
oFld.Code.Text = StrTmp
End With
Loop
ActiveDocument.ActiveWindow.View.ShowFieldCodes = bFldCodes
.End = .End - 1
If bFldCodes = False Then .Fields.ToggleShowCodes
.Select
End With
Application.ScreenUpdating = True
sUpdate = MsgBox("Do you wish to update the fields?" & vbCr + vbCr & _
"Note that if the converted fields include ASK or FILLIN fields, " & _
"updating will force the prompt for input to those fields", vbYesNo, Title2)
If sUpdate = vbYes Then RngFld.Fields.Update
Set RngTmp = Nothing
Set RngFld = Nothing
Set oFld = Nothing
End Sub