IDEAScripting and More

Returns a value 1–7 representing the day of the week. The optional firstdayofweek argument specifies the first day of the week; the default is Sunday. The firstdayofweek option in IDEAScript does not seem to work.

Read more about Weekday()
Log in or register to post comments

FormatDateTime(Date, NamedFormat)

Brian Element

Sat, 07/14/2012 - 19:40

Date is the date expression to be formatted. NamedFormat is an optional constant that specifies how the date is formatted.

Read more about FormatDateTime(Date, NamedFormat)
Log in or register to post comments

Static Arrays

Brian Element

Sat, 07/14/2012 - 19:40

A static array has a fixed size or number of elements. You specify the array size when you declare it, and the size cannot change during program execution. The size will be one more than n because VBA array indexes start by default at 0.

You can use an integer variable or constant as the index.

Dynamic Arrays

Brian Element

Sat, 07/14/2012 - 19:39

A dynamic array does not have a fixed size. It can be enlarged or shrunk as needed by code during program execution. A dynamic array is declared by using empty parentheses in the Dim statement.

Before using the array, you must set its size using the ReDim statement.

Subscribe to