CapeSoft Office Inside
Version History

• msWord.SetStyle - sets the style of the current selection
• Updated the msOutlook.NewMail method . Supports getting the Attachments object for a mail item and adding new attachments; setting the HTML body as well as the text body, and auto saving a draft:
  
  msOutlook.NewMail Procedure (<string subject>, <string mailTo>, <string body>, <string htmlBody>, <*msAttachmentsList attachments>, bool autoSave=false)
• Added automated Outlook restart to the Generics example (this is already demonstrated in the oiMail example). This functionality detects the Quit event if the user exits Outlook while the application is automating it, and creates a new instance of Outlook for automation to continue functioning.

• Init() - calls the parent's Init method and stores the current thread number for event handling
• New event handling methods:
  EventItemSend Procedure (), derived
  EventNewMail Procedure (), derived
  EventReminder Procedure (), derived
  EventOptionsPagesAdd Procedure (), derived
  EventStartup Procedure (), derived
  EventQuit Procedure (), derived
• TakeEvent - handles events from the current thread
• OnQuit - traps the Quit event for Outlook and checks whether Outlook was closed by the object or the user. If the user closes Outlook it is re-initialized.
• RestartOutlook - Restarts Outlook in the background if the user closed the last Outlook window or inspector.

• New msOutlook.GetFilteredMail method retrieves all items in the specified folder using column restriction and optionally record filtering in
• New msOutlook.MailByDate demonstrates using the mail filtering to retrieve mail that matches a date range
• New msOutlook.FindMail method demonstrates using Find and FindNext to retrieve mail that matches a filter expression.
• Demonstrates Restrict, SetSort, SetColumns, FirstItem, NextItem, ResetColumns, FindItems, FindNext etc.
• Added benchmarking of the various approaches to filtering and retrieving mail. Test benchmark results with 806 items in the Inbox:
  • Fetch all 806 items using SetColumns in the msOutlook.GetFilteredMail example method to optimize the record retrieval:
    
    1.74 seconds
    
  • With Restrict to limit mail being fetched to the desired range using the msOutlook.GetFilteredMail example method:
    
    0.04 seconds
    
  • Using FindItems and FindNext to filter and fetch mail items (See the msOutlook.FindMail example method):
    
    0.05 seconds
    
  • Using the old GetMailItemsQ method to fetch all items:
    
    9.55 seconds
    

• Using the Worksheets, ActiveSheet and Range object
• Passing an Object as a parameter to a Office method (this is a Work In Progress)

• GetObjects Procedure (), bool, virtual
• MergeFiles Procedure (FILE:queue filesQ), bool, virtual
• InsertFile Procedure (string fileName), bool, virtual
• PasteAndFormat Procedure (long formatType = oiw:FormatOriginalFormatting), bool, virtual
• NewDoc Procedure (<string template>, long newTemplate = oi:False, long documentType=oiw:NewBlankDocument, long visible=oi:True), bool, virtual
• GetCellValues Procedure (*WordTableCells cells, long tableNum = 1), bool, virtual

• PicasToPoints procedure (long pPicas), long, name('PICASTOPOINTS@F15OIOFFICE')
• PixelsToPoints procedure (long pPixels), real, name('PIXELSTOPOINTS@F15OIOFFICE')
• PointsToCentimeters procedure (long pPoints), real, name('POINTSTOCENTIMETERS@F15OIOFFICE')
• PointsToInches procedure (long pPoints), real, name('POINTSTOINCHES@F15OIOFFICE')
• PointsToLines procedure (long pPoints), real, name('POINTSTOLINES@F16OIWORD')
• PointsToMillimeters procedure (long pPoints), real, name('POINTSTOMILLIMETERS@F15OIOFFICE')
• PointsToPicas procedure (long pPoints), real, name('POINTSTOPICAS@F15OIOFFICE')
• PointsToPixels procedure (long pPoints), long, name('POINTSTOPIXELS@F15OIOFFICE')
• LinesToPoints procedure (long pLines), long, name('LINESTOPOINTS@F15OIOFFICE')
• InchesToPoints procedure (real pInches), real, name('INCHESTOPOINTS@F15OIOFFICE')
• CentimetersToPoints procedure (real pCentimeters), real, name('CENTIMETERSTOPOINTS@F15OIOFFICE')
• MillimetersToPoints procedure (real pMillimeters), real, name('MILLIMETERSTOPOINTS@F15OIOFFICE')

• All the oiObject functionality which this example is based on has been moved into three classes - msWord, msExcel and msOutlook. These are in the msOffice.clw and msOffice.inc files in the example folder. These classes provide all the normal functionality provided by the OfficeInside classes and expand on them. They serve as an excellent basis for building your own classes to expand the built in functionality as needed. The functionality and parameters of each method are documented above each method in the CLW file.
• ConvertUnits procedure - a generic procedure to convert between millimeters, points and centimeters. Handles all input and output units.
• Extensive Page Setup example code and interface. Demonstrates using the PageSetup object and creating a user interface for the properties. Also demonstrates retrieving the PageSetup values from Excel.

• Requires FileExplorer 5.31 or later
• Removed old code.
• Initial HTML populated into the control to demonstrate the use of the EditorReady method as well as populating the control for formatted HTML with a number of spelling errors for spell checking.
• Updated the Editor Files being used by the example

• Mail creation
• Sending and receiving (synchronization)
• Moving mail between folders
• Retrieving a specific folder
• Retrieving a Message object
• Saving items as all formats supported by Outlook (Text, Word, MSG, Unicode MSG, vCard, vCal, iCal etc.)
• Retrieving appointment objects and getting and setting their properties and calling methods

• Construct Procedure ()
• Destruct Procedure ()
• Free Procedure ()
• Count Procedure ()
• Fetch Procedure (long pos)
• AddString Procedure (string sVal, long pType = 0)
• AddBString Procedure (string bs)
• AddInt Procedure (long pVal, bool isBool=false)
• Insert Procedure (*long pVal, bool isBool=false)
• Insert Procedure (*ulong pVal)
• Insert Procedure (*string pVal)
• Insert Procedure (*cstring pVal)
• Insert Procedure (*short pVal)
• Insert Procedure (*ushort pVal)
• Insert Procedure (*byte pVal, bool fUnsigned = false)
• Insert Procedure (*real pVal),
• Insert Procedure (*sreal pVal)
• Insert Procedure (*decimal pVal)
• Insert Procedure (*long pDate, *long pTime)
• Insert Procedure (*oiVariant pVal)
• Insert Procedure (*oiObject pObj)
• _AddVariant Procedure (long pVar)
  

• Creating a new mail message and setting the values for properties such as the Subject, Body and To fields.
• Saving a mail message to disk in a variety of formats such as text, HTML, MSG, Word Doc etc. (this demonstrates the new oiParams class which allows any number of parameters to be passed when accessing methods and properties of the Office objects).
• Send and Receive All (Synchronise). Demonstrates getting a collection (of Synch objects), looping through the collection and getting each object within it, and calling a method of that object.
• Listing, retrieving and modifying Appointments items (this code existed in previous versions of the example, but has been improved).
• New oiWord example, demonstrates basic functionality - custom Pasting setting the formatting options

• Construct Procedure ()
• Destruct Procedure ()
• Init Procedure ()
• InitExcel Procedure ()
• Kill Procedure ()
• Open Procedure (string p_FileName)
• NewWorkbook Procedure (string p_FileName)
• SaveFile Procedure ()
• OpenFile Procedure ()
• CloseFile Procedure ()
• With Procedure (*File f)
• With Procedure (*Queue q)
• With Procedure (*Group g)
• With Procedure (*View v)
• Load Procedure (*File p_File, string p_FileName)
• Load Procedure (*Group p_Group, string p_FileName)
• Load Procedure (*Queue p_Queue, string p_FileName)
• Load Procedure (string p_FileName)
• SetupLoad Procedure ()
• Save Procedure (*Group p_Group, string p_FileName)
• Save Procedure (*File p_File, string p_FileName)
• Save Procedure (*Queue p_Queue, string p_FileName),long
• Save Procedure (*View p_View, string p_FileName)
• Save Procedure (*string p_FileName)
• SetupSave Procedure()
• SaveData Procedure()
• TakeInit Procedure ()
• TakeSetup Procedure ()
• TakeComplete Procedure ()
• ValidateRecord Procedure ()
• TakeRecord Procedure (*excelImportQType cellsQ)
• InsertRecord Procedure ()
• AssignField Procedure ()
• IgnoreField Procedure (long fieldNum)
• ClearIgnored Procedure ()
• Close Procedure ()
• CloseAndKill Procedure ()
• CreateFooter Procedure ()
• CreateHeader Procedure ()
• AddMap Procedure (long fieldPos colPos)
• SetMap Procedure (*oiColumnMap qMap)
• GetMap Procedure (*oiColumnMap qMap)
• CreateMap Procedure ()
• ClearMap Procedure ()
• FieldName Procedure (long fieldPos), string
• ColumnName Procedure(long columnNumber), string
• CountFields Procedure()
• SetHeader Procedure (string headerText, long colPos)
• HeadersFromFields Procedure (long caseType = 0, long keepPrefix = false)
• RunFile Procedure (string fileName)
• FreeData Procedure ()
• FreeFileData Procedure ()
• FreeQueueData Procedure ()
• FreeGroupData Procedure ()
• ProgressControl Procedure (long progressControl)
• ProgressSetup Procedure (long rangeLow rangeHigh)
• ProgressSet Procedure (long progress)
• ProgressIncrement Procedure ()
• DbgMsg Procedure (string pDbgMessage)
• ErrorTrap Procedure (string errorMessage, string functionName)
• IsIgnored Procedure (long pos)

• _ClearReferences Procedure ()
• _ClearAutos Procedure ()
• _GetRecord Procedure ()
• _GetViewRecord Procedure (long fieldPos)
• _ClearRecord Procedure ()
• _SetHeaderText Procedure(*string hText)
  

• PrintSheet procedure (*oixPrintProperties printSettings)
• PrintWorkbook procedure (*oixPrintProperties printSettings)
• _PrintOut Procedure (*oixPrintProperties printSettings, long pType=oix:PrintWorkbook)
• SetAlerts Procedure (long alertLevel)
• GetActiveSheet Procedure (*oiObject iSheet)

! Data
Outlook       oiOutlook
Namespace     oiObject
Appointment   oiObject
Recipients    oiObject
Attendee      oiObject
ItemID        string(_oit:EntryIDSize)  ! Standard Entry ID
attendeeList  string(1024)  ! semi colon seperated list of attendees

! Code 
AddAttendee routine
    ident = 'MAPI'
    if Outlook.iApplication.GetChild('GetNamespace', Namespace, ident)
        ! Get the specific appointment object
        if Namespace.GetChild('GetItemFromID', Appointment, ItemID)
            Appointment.Set('BusyStatus', oio:Busy) ! Example of setting a property

            ! Get the Recipients object that is a child of the Appointment
            if Appointment.GetChild('Recipients', Recipients)      

                ! The recipients object is now fully accessible, so for example,
                ! Add a recipient and get the returned object so that it can be modified.
                if Recipients.GetChild('Add', Attendee, attendeeName)  ! Add to the recpients
                    Message('Attendee Added.')
                    Attendee.Set('Type', oio:Required)
                else
                    Message('Failed to add an Attendee.')
                end

                ! Other methods available for the Recpients object include:
                ! Add(), Item(), Remove() and RemoveAll()

                Appointment.Call('Save')

                ! Refresh the list of attendees (C55 users should call GetProp instead of Get). 
                Appointment.Get('RequiredAttendees', attendeeList)
                Display(?attendeeList)
            end
        else
            Message('Could not get the requested appointment, the ID may be invalid.')
        end
    end

    Do Cleanup

• Init - creates the object, using the passed name:
  iSheet               oiObject
  ExcelBook            oiExcel   ! Instance of the oiExcel class
    code
      ExcelBook.Init()
      ! Get the active sheet from an oiExcel object:
      iSheet.Init('ActiveSheet', ExcelBook.iApplication) 
• GetChild - gets a child object, such as a MailItem from a Folder or a Sheet from a Workbook.
  ! Identical in function to the code above for the Init method,
  ! just gets the child ActiveSheet from the Application
  ExcelBook.iApplication.GetChild('ActiveSheet', iSheet)
• GetParent - retrieves the parent object.
  ! Use to retrieve a parent object of the passed object.
  iSheet.GetParent(iWorkbook)
• GetProperty - gets the value a property of the object using the property name. For example:
  iWorkbook.GetProperty('FullName', workbookFileName) ! get the file name of the workbook
• SetProperty - Sets the property of the object to the passed value. Example:
  iActiveSheet.SetProperty('Name', 'Accounts Nov')   ! set the Name property of the active Sheet
• CallMethod - call a method of the object. Example:
  iSelectedSheet.CallMethod('PrintPreview', oi:False) ! Print the selected sheets

• 14     Office 2010
• 12     Office 2007
• 11     Office 2003
• 10     Office XP
• 9       Office 2000

• Notes:
  1. When using the PrintOut method the printer to use can be passed directly to the method, and SetPrinter does not need to be called.
  2. If no printer is set (for both a mail merge and when calling PrintOut), then the current printer (usually the system default) is used.

• _InitWordSelection()
• _InitRange() - creates the range interface
• _WrapperSelection() - handles SetSelection(); MoveLeft() etc. Will be replaced and deprecated in future versions.
• _WrapperDocument() - handles document level options such as self.SetBackground(). Will be replaced and deprecated in future versions.
• _KillRange()
• _InitTables()
• _InitInlineShapes()
• _WrapperParagraphFormat() - will be replaced in future versions.
• CheckSpelling_Init()
• _WrapperStoryRanges() - will be replaced in future versions
• _InitInlineShapes()
• InsertPicture()
• SaveAs()
• Underline()
• _WrapperWordFont() - will be replaced in future versions
• _InitWordFont()
• _InitPageSetup()
• _InitSystem()
• GetFileName()
• CountCharacters()
• SetSelection()
• _WrapperTableRows()
• Undo()
• _WrapperDocument() - Complete re-write. Will be split into individual methods using the new interfaces, and deprecated, along with all other "wrapper" methods.
• Redo()
• RefreshScreen()
• _WrapperActivePane() - will be replaced in future versions.
• _WrapperCommandBar() - will be replaced in future versions.
• ShowToolbar()
• HideToolbar()
• CountOpenDocs ()
• PrintPreview()
• PrintPreview(long)
• CheckSpelling_Init()
• SetActivePrinter()
• CountCharacter - complete rewrite, now calls DocumentStatistics

• NewDoc()
• OpenDoc()
• CloseDoc()

• _KillApplication
• _KillSystem

• GetDocuments - Gets the Documents interface
• GetActiveDocument - Get the ActiveDocument interface
• GetRange - Get the Range interface
• GetWindow - Get the ActiveWindow interface
• GetPane - Get the ActivePane interface
• StoreDoc - Stores each new or opened document in the Documents queue as an oiObject
• RemoveDoc - Removes a document from the .Documents queue, typically when it is closed.
• ReleaseDocs - Clears the .Documents queue and releases all memory allocated.
• GetDialogs - Get ths Dialogs interface and the Dialog interface for the File->Printers dialog (used for setting the active printer for Word).

• DeleteSelection - Delete a selection
• RefreshDocs - Refreshes the list of available documents and populates the .Documents queue with all the currently open documents.

• _WrapperRange - will be replaced in future releases
• InsertRow
• WriteToCell
• SelectCells
• InsertColumn
• SetCellBackgroundColor
• GetCellBackgroundColor
• CountUsedRows - complete replacement, encapsulates the functionality within the method itself, and adds full error handling. Returns the number of rows that contain data, or returns -1 if an error occurs and calls the ErrorTrap() method

• oiw:StatisticCharacters: Count of characters.
• oiw:StatisticCharactersWithSpaces: Count of characters including spaces.
• oiw:StatisticFarEastCharacters: Count of characters for Asian languages.
• oiw:StatisticLines: Count of lines.
• oiw:StatisticPages: Count of pages.
• oiw:StatisticParagraphs: Count of paragraphs.
• oiw:StatisticWords: Count of words.

• SpellCheckString
• SpellCheckHtml
• SpellCheckRTF
• ReplaceInString

• GetRtfText
• ReplaceRtfText
• SpellWord

• GetProperty - gets the value a property of the object using the property name. For example:
  iWorkbook.GetProperty('FullName', workbookFileName) ! get the file name of the workbook
• SetProperty - Sets the property of the object to the passed value. Example:
  iActiveSheet.SetProperty('Name', 'Accounts Nov')   ! set the Name property of the active Sheet
• CallMethod - call a method of the object. Example:
  iSelectedSheet.CallMethod('PrintPreview', oi:False) ! Print the selected sheets
• Init - creates the object, using the passed name:
  iSheet.Init('ActiveSheet', ExcelBook.iApplication)  ! Get the active sheet from an oiExcel object
  iSheet.GetChild('PageSetup', iPageSetup)  ! Get the PageSetup for the sheet
  centerFooter = 'My Worksheet'  ! A string for the center footer contents
  iPageSetup.SetProperty('CenterFooter', centerFooter) ! Set the center footer to our string
• GetChild - gets a child object, such as a MailItem from a Folder or a Sheet from a Workbook.
• GetParent - retrieves the parent object.

• The new Editable Report output engine for Excel extends the output abilities and now creates well formatted Excel spreadsheet without requiring specific alignment and sizing of controls.
• Intelligent column and row checking allows controls to be automatically assigned to the correct column and row without specific alignment requirement
• Improved report processing speed (additional performance improvements are coming in future releases).

• oiWord.EventStartup( )
• oiWord.EventQuit( )
• oiWord.EventDocumentChange( )
• oiWord.EventDocumentOpen( )
• oiWord.EventDocumentBeforeClose( )
• oiWord.EventDocumentBeforePrint( )
• oiWord.EventDocumentBeforeSave( )
• oiWord.EventNewDocument( )
• oiWord.EventWindowActivate( )
• oiWord.EventWindowDeactivate( )
• oiWord.EventWindowSelectionChange( )
• oiWord.EventWindowBeforeRightClick( )
• oiWord.EventWindowBeforeDoubleClick( )
• oiWord.EventEPostagePropertyDialog( )
• oiWord.EventEPostageInsert( )
• oiWord.EventMailMergeAfterMerge( )
• oiWord.EventMailMergeAfterRecordMerge( )
• oiWord.EventMailMergeBeforeMerge( )
• oiWord.EventMailMergeBeforeRecordMerge( )
• oiWord.EventMailMergeDataSourceLoad( )
• oiWord.EventMailMergeDataSourceValidate( )
• oiWord.EventMailMergeWizardSendToCustom( )
• oiWord.EventMailMergeWizardStateChange( )
• oiWord.EventWindowSize( )
• oiWord. EventXMLSelectionChange( )
• oiWord.EventXMLValidation( )
• oiWord.ErrorEventDocumentSync( )
• oiWord. EventEPostageInsertEx( )
• oiWord.EventMailMergeDataSourceValidate2( )
• oiWord.EventUnknown( )

• "Warn me about suspicious activity when my antivirus software is inactive or out of date (recommended)".
  This setting does not appear to function correctly when most setups. Presumably it is meant to allow the antivirus software to determine whether access is allowed or not. Instead in every configuration tested it simply blocks all access, which means that sending mail will fail because the Recipient object cannot be retrieved. Outlook provides no indication of the failure, or the reason for it.
• "Always warn me about suspicious activity".
  This setting operates in the same manner as the security model in Outlook 2003, except that it introduces an even more onerous warning dialog box on mail sending. First the user is prompted to allow access to 1, 5 or 10 minutes, then when an email is sent a warning dialogue is displayed (because the first dialog is actually a security flaw). The second dialog does not allow the user to continue immediately, but instead displays a progress bar for a few seconds before the button can be pressed. This means that utilities such as "ClickYes" can no longer be used.
• "Never warn me about suspicious activity".
  This setting allows all applications access, much like in Office 2000 and XP.
• Unfortunately all three of the settings are essentially useless - either they are overly onerous for the user, or they provide no protection against malicious software (even the option to always warn of suspicious activity can be overridden by malicious software). One solution to this is to install the free Advanced Security for Outlook from MAPILabs (http://www.mapilab.com/outlook/security/). This allows the user to choose whether an application is trusted when it tries to access Outlook. This approach only requires the user to allow (or deny) an application access once, which provides good protection, without any burden on the end user.

• Background (optional). True to have the macro continue while Microsoft Word prints the document.
• pAppend (optional). True to append the specified document to the file name specified by the OutputFileName argument. False to overwrite the contents of OutputFileName.
• pRange (optional). The page range. Can be one of the following WdPrintOutRange constants: wdPrintAllDocument, wdPrintCurrentPage, wdPrintFromTo, wdPrintRangeOfPages, or wdPrintSelection.
• OutputFileName (optional). If PrintToFile is True, this argument specifies the path and file name of the output file.
• pFrom (optional). The starting page number when Range is set to wdPrintFromTo.
• pTo (optional). The ending page number when Range is set to wdPrintFromTo.
• Item (optional). The item to be printed. Can be one of the following WdPrintOutItem constants: wdPrintAutoTextEntries, wdPrintComments, wdPrintDocumentContent, wdPrintKeyAssignments, wdPrintProperties, or wdPrintStyles.
• Copies (optional). The number of copies to be printed.
• Pages (optional). The page numbers and page ranges to be printed, separated by commas. For example, "2, 6-10" prints page 2 and pages 6 through 10.
• PageType (optional). The type of pages to be printed. Can be one of the following WdPrintOutPages constants: wdPrintAllPages, wdPrintEvenPagesOnly, or wdPrintOddPagesOnly.
• PrintToFile (optional). True to send printer instructions to a file. Make sure to specify a file name with OutputFileName.
• Collate (optional). When printing multiple copies of a document, True to print all pages of the document before printing the next copy.
• FileName (optional). The path and file name of the document to be printed. If this argument is omitted, Word prints the active document. Available only with the Application object.
• ActivePrinterMacGX (optional). This argument is available only in Microsoft Office 98 Macintosh Edition. For additional information about this argument, consult the language reference Help included with Microsoft Office 98 Macintosh Edition.
• ManualDuplexPrint (optional). True to print a two-sided document on a printer without a duplex printing kit. If this argument is True, the PrintBackground and PrintReverse properties are ignored. Use the PrintOddPagesInAscendingOrder and PrintEvenPagesInAscendingOrder properties to control the output during manual duplex printing. This argument may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed.
• PrintZoomColumn (optional). The number of pages you want Word to fit horizontally on one page. Can be 1, 2, 3, or 4. Use with the PrintZoomRow argument to print multiple pages on a single sheet.
• PrintZoomRow (optional) . The number of pages you want Word to fit vertically on one page. Can be 1, 2, or 4. Use with the PrintZoomColumn argument to print multiple pages on a single sheet.
• PrintZoomWidth (optional). The width to which you want Word to scale printed pages, in twips (20 twips = 1 point; 72 points = 1 inch).
• PrintZoomHeight (optional). The height to which you want Word to scale printed pages, in twips (20 twips = 1 point; 72 points = 1 inch).

• oio:TaskCategories equate(13)
• oio:TaskCompanies equate(14)
• oio:TaskComplete equate(15)
• oio:TaskIsConflict equate(16) ! read only
• oio:TaskDateCompleted equate(17)
• oio:TaskTimeCompleted equate(18)
• oio:TaskIsRecurring equate(19) ! read only
• oio:TaskNoAging equate(20)
• oio:TaskOwner equate(21)
• oio:TaskPercentComplete equate(22)
• oio:TaskSize equate(23) ! size in bytes, read only
• oio:TaskStatus equate(24)
• oio:TaskStatusOnCompletionRecipients equate(25) ! recipients who will receive notification on completion
• oio:TaskStatusUpdateRecipients equate(26) ! recipients who will receive notification when the task is updated
• oio:TaskTeamTask equate(27) ! set to true if this is a team task
• oio:TaskTotalWork equate(28)
• oio:TaskUnRead equate(29)

• Microsoft Office Word format (.doc)
• HTML format (.html)
• iCal format (.ics)
• MIME HTML format (.mht)
• Outlook message format (.msg)
• Outlook Unicode message format (.msg)
• Rich Text format (.rtf)
• Microsoft Office Outlook template (.oft)
• Text format (.txt)
• VCal format (.vcs)
• VCard format (.vcf)

• oix:WrapText
• oix:HorizontalAlignment
• oix:VerticalAlignmentszMemberof
• oix:Indent
• oix:ShrinkToFit
• oix:TextDirection
• oix:Orientation

• Categories
• Companies
• FlagRequest
• Importance
• IsMarkedAsTask
• LastModificationTime
• LastModificationDate
• ReceivedByName
• ReceivedTime
• ReceivedDate
• ReplyRecipientNames
• SentOnBehalfOfName
• UnRead

• Categories
• Companies
• Complete
• IsConflict
• DateCompleted
• TimeCompleted
• IsRecurring
• NoAging
• Owner
• PercentComplete
• Size
• Status
• StatusOnCompletionRecipients
• StatusUpdateRecipientsTeamTask
• TotalWork
• UnRead

• SetCalculations: Allows automatic calculation of each inserted or edited cell in Excel to be turned off. This can dramatically increase the speed of writing large numbers of cells to Excel, and once complete automatic calculation can be turned back on using the same method.
• Calculate: Forces the values of all formulas in all open workbooks to be calculated. Useful if SetCalculations has turned off automatic cell value calculation and the values need to be calculated at some point.
• SetScreenUpdating:Allows screen updating to be turned off and on in Excel. This can also dramatically improve performance when inserting large numbers of cells.

• oiDecToBase: Converts from a decimal (base 10) to any other base, for example Hexidecimal (base 16), binary (base2) etc.
• oiBaseToDec: Converts from any base to a decimal number. For example convert Hexidecimal or binary to decimal.

• oiRecentFiles: Stores a list of recent files for all of the Office applications (Word, Excel, Powerpoint and Outlook). This class is automatically initialised when the main object is, and filled with a list of recent files, which can then be accessed by looping through the queue. The class also contains methods to refresh the queue, delete files, open files etc.
• oiRecentFile: Class used by the RecentFiles class, and represents an individual file in the list. This class will typically not be accessed directly.