9.0

170
Description
Execute statements for each item in items.
Parameter Description
ar This is the iteration variable.
items This is the collection of items to be done.
See Also: Do
, For, Exit For, While.
Example
Sub Main
Dim
Document As Object
For
Each Document In App.Documents
Debug
.Print Document.Title
Next Document
End
Sub
Format$ Function
Syntax
Format[$](expr[, form$], [firstday], _
[firstweek
])
Group
String
Description
Return the formatted string representation of expr.
Parameter Description
expr Return the formatted string representation of this numeric value.
form Format expr using to this string value. If this is omitted then return the expr as a
string.
firstday Format using this day as the first day of the week. If this is omitted then the
vbSunday is used. (Only supported for Win32.)
firstweek Format using this week as the first week of the year. If this is omitted then the
vbFirstJan1 is used. (Only supported for Win32.)
firstday Value Description
vbUseSystemFirstDay 0 Use the systems first day of the week.
vbSunday 1 Sunday (default)
vbMonday 2 Monday
vbTuesday 3 Tuesday
vbWednesday 4 Wednesday
vbThursday 5 Thursday
vbFriday 6 Friday
vbSaturday 7 Saturday
firstweek Value Description
vbUseSystem 0 Use the systems first week of the year
vbFirstJan1 1 The week that January 1 occurs in. This is the default value.