Rainier Software Solutions

     

RainierFun

 Function Lists and version checking

 

###  New printer setting functions in WinFun   ###

###  New spellcheck functions in WordFun   ###

### Many new ExcelFun functions   ###
Products Downloads Subscribe Contact Us What's New Home Customers Support Buy
 Function Lists

This page gives complete lists of the functions in the latest versions of WinFun, WordFun, ExcelFun and MailFun. New functions are continually being added in response to user requests. New functions are easily identifiable - see if the latest version contains something you need. And if it doesn't contain what you need, let us know.

To determine your current version, right-click on the rnWinFun, rnWordFun, rnExcelFun or rnMailFun DLL in Windows Explorer and choose Properties. Then select the Version tab. The DLLs will normally be found in your \program files\common files\olesvr directory.

If you find you require an upgrade, please contact support@rainier.co.uk  

Note: all even numbered versions (e.g. 1.1.4) are evaluation versions. All odd numbered versions (e.g. 1.1.5) are commercial versions.

If you are searching for help with a specific problem, see also the FAQ and Troubleshooting page.

 

                     WinFun         Windows Functions
WordFun Microsoft Word Functions
ExcelFun Microsoft Excel Functions
MailFun Email Functions


WinFun Functions

Latest version: 2.0.1

 

(1.0.49) rnAddWindowStyle(hWnd As Long, Style As Long) As Long

rnAscii(InString As String) As Long

rnBringWindowToTop(hWnd As Long) As Long

rnBringWindowToTopNoActivate(hWnd As Long) As Long

rnButtonClick(hButton As Long) As Long

rnCenterWindow(hWnd As Long) As Long

rnChangeWindowState(hWnd As Long, NewState As Long) As Long

rnCharacter(CharCode As Long) As String

rnClipboardClear() As Long

rnClipboardGetText() As String

rnClipboardPutText(TextString As String) As Long

rnCloseClassWindow(WindowClass As String) As Long

rnCloseNamedWindow(WindowName As String) As Long

rnCloseWindow(hWnd As Long) As Long

rnCreateDirectory(DirPath As String) As Long

rnDeleteMenuItem(hMenu As Long, ByPositionOrCaption As String, Item As String) As Long

rnDirectory(Pathname As String) As String

rnDirectoryExists(DirPath As String) As Long

rnDisableWindow(hWnd As Long) As Long

rnEnableWindow(hWnd As Long) As Long

rnFileExists(FilePath As String) As Long

rnFileModifiedDate(FilePath As String) As Long

rnFileModifiedTimestamp(FilePath As String) As String

rnFileSize(FilePath As String) As Long

rnFindWindowByClass(ClassName As String) As Long

rnFindWindowByName(WindowName As String, MatchType As Long) As Long

rnFlashWindow(hWnd As Long) As Long

rnFormatNumberAsString(InNumber As Single, FormatDefinition As String) As String

rnFormatNumericString(InString As String, FormatDefinition As String) As String

rnGetButtonHandle(hWnd As Long, ButtonCaption As String) As Long

rnGetCurrentCommandLine() As String

rnGetCurrentDirectory(DriveLetter As String) As String

(1.0.49) rnGetCurrentProcessId() As Long

(2.0.1) rnGetDefaultPrinterName() As String

rnGetDesktopWindow() As Long

rnGetDiskFreeSpace(DriveLetter As String) As Long

rnGetDiskTotalSpace(DriveLetter As String) As Long

rnGetDriveLetters() As String

rnGetDriveType(DriveLetter As String) As Long

rnGetEnvironmentVariable(VariableName As String) As String

rnGetForegroundWindow() As Long

rnGetIniFileInt(AppName As String, KeyName As String, nDefault As Long, IniFileName As String) As Long

rnGetIniFileString(AppName As String, KeyName As String, lpDefault As String, IniFileName As String) As String

rnGetLastErrorNumber() As Long

rnGetLastErrorText() As String

rnGetMainMenuHandle(hWnd As Long) As Long

rnGetMenuItemCaption(hMenu As Long, ItemNumber As Long) As String

rnGetMenuItemCount(hMenu As Long) As Long

(1.0.49) rnGetProcessIdFromWindowHandle(hWnd As Long) As Long

rnGetRelatedWindow(hWnd As Long, Relationship As Long) As Long

rnGetScreenHeight() As Long

rnGetScreenWidth() As Long

rnGetSessionTime() As Long

rnGetSubMenuHandle(hMenu As Long, ByPositionOrCaption As String, Item As String) As Long

rnGetSystemDateTime() As String

rnGetWindowCaption(hWnd As Long) As String

(1.0.47) rnGetWindowClassName(hWnd As Long) As String

rnGetWindowCoordinateBottom(hWnd As Long) As Long

rnGetWindowCoordinateLeft(hWnd As Long) As Long

rnGetWindowCoordinateRight(hWnd As Long) As Long

rnGetWindowCoordinateTop(hWnd As Long) As Long

rnGetWindowsDirectory() As String

(1.0.45) rnGetWindowsPlatform() As String

rnGetWindowState(hWnd As Long) As Long

rnGetWindowsVersion() As String

rnGetWinIniFileInt(AppName As String, KeyName As String, nDefault As Long) As Long

rnGetWinIniFileString(AppName As String, KeyName As String, lpDefault As String) As String

rnGetWinSysDirectory() As String

rnHideWindow(hWnd As Long) As Long

(1.0.49) rnIsMenuItemEnabled(hMenu As Long, ByPositionOrCaption As String, Item As String) As Long

(1.0.43) rnIsProcessRunning(ProcessId As Long) As Long

(2.0.1) rnIsStringDate(InString As String) As Long

rnIsStringNumeric(InString As String) As Long

(1.0.49) rnKillProcess(ProcessId As Long) As Long

rnLockWindowUpdate(hWnd As Long) As Long

rnMakeWindowAlwaysOnTop(hWnd As Long) As Long

rnMaximizeWindow(hWnd As Long) As Long

rnMenuItemClick(hWnd As Long, hMenu As Long, ByPositionOrCaption As String, Item As String) As Long

rnMinimizeWindow(hWnd As Long) As Long

rnMonitorKeyStart(KeyCode As Long, hWndButtonToNotify As Long, TimerInterval As Long) As Long

rnMonitorKeyStop() As Long

rnPopUpMenuAuto(hWndOwningWindow As Long, MenuItemNumber As Long) As Long

rnPopUpMenuCustom(Captions As String, Delimiter As String, SeparatorIndicators As String, DisabledIndicators As String) As Long

rnPostMessageToWindow(hWnd As Long, Message As Long, Param1 As Long, Param2 As Long) As Long

rnPostMessageToWindowByString(hWnd As Long, Message As Long, Param1 As Long, StringParam2 As String) As Long

(1.0.47) rnPreventWindowClose(hWnd As Long) As Long

rnPreventWindowMove(hWnd As Long) As Long

rnPreventWindowResize(hWnd As Long) As Long

rnPrinterList() As String

rnPrinterSelectByName(DeviceNameString As String, MatchType As Long) As Long

rnPrintText(TextToPrint As String, FontName As String, FontSize As Long, Orientation As Long) As Long

rnPrintTextFile(Filename As String, FontName As String, FontSize As Long, Orientation As Long) As Long

rnRemoveDirectory(DirPath As String) As Long

rnRemoveLeadingZeros(NumberAsString As String) As String

(1.0.49) rnRemoveWindowStyle(hWnd As Long, Style As Long) As Long

rnRestoreWindow(hWnd As Long) As Long

rnSendMessageToWindow(hWnd As Long, Message As Long, Param1 As Long, Param2 As Long) As Long

rnSendMessageToWindowByString(hWnd As Long, Message As Long, Param1 As Long, StringParam2 As String) As Long

rnSetCurrentDirectory(Path As String) As Long

rnSetCurrentDrive(DriveLetter As String) As Long

(2.0.1) rnSetDefaultPrinter(DeviceName As String) As Long

rnSetFocus(hWnd As Long) As Long

rnSetForegroundWindow(hWnd As Long) As Long

rnSetMenuItemCaption(hMenu As Long, ByPositionOrCaption As String, Item As String, NewCaption As String) As Long

rnSetSystemClock(tYearAs Long, tMonth As Long, tDay As Long, tHour As Long, tMinute As Long, tSecond As Long) As Long

rnSetWindowCaption(hWnd As Long, Caption As String) As Long

rnSetWindowCoordinates(hWnd As Long, cTop As Long, cLeft As Long, cBottom As Long, cRight As Long) As Long

rnSetWindowNoCaptionBar(hWnd As Long) As Long

rnSetWindowRedrawOff(hWnd As Long) As Long

rnSetWindowRedrawOn(hWnd As Long) As Long

rnShell(CmdLine As String, WorkingDirectory As String, WindowStyle As Long) As Long

(1.0.43) rnSleep(IntervalMilliseconds As Long) As Long

rnUpdateWindow(hWnd As Long) As Long

rnUnlockWindowUpdate() As Long

(1.0.45) rnWriteEventLogEntry(ApplicationName As String, MessageText As String, MessageType As String, EventId As Long, Category As Long) As Long

rnWriteIniFileString(AppName As String, KeyName As String, WriteString As String, IniFileName As String) As Long

rnWriteWinIniFileString(AppName As String, KeyName As String, WriteString As String) As Long

rnYield(hWnd) As Long

 


WordFun Functions

Latest version: 2.0

First Office 2000 compliant version: 1.1.2

First Office XP compliant version: 2.0

 

rnFindWdWindow() As Long

rnWdActivateDocumentWindow(WindowCaption As String) As Long

rnWdApplyStyle(StyleName As String) As Long

rnWdBookmarkExists(BookmarkName As String) As Long

rnWdClearSelection() As Long

rnWdClose() As Long

rnWdCloseDocument(DocumentName As String, PromptForSave As Long, FreezeWord As Long) As Long

(1.1.5) rnWdCopy() As Long

(1.1.5) rnWdCut() As Long

rnWdFreeze() As Long

rnWdGetActiveDocumentName() As String

(1.1.3) rnWdGetDocumentProperty(PropertyType As String) As String

rnWdGetLastErrorNumber() As Long

rnWdGetLastErrorText() As String

rnWdGetSelectedText() As String

rnWdGoto(Destination As String) As Long

rnWdInsertFile(FileName As String) As Long

(1.1.3) rnWdInsertPageBreak() As Long

rnWdInsertPicture(FileName As String) As Long

(1.1.3) rnWdInsertSectionBreak(BreakType As Long) As Long

rnWdInsertText(InsertString As String) As Long

rnWdLaunch(WindowState As Long) As Long

rnWdLaunchNewInstance(WindowState As Long) As Long

rnWdMailMergeDocument(TemplatePath As String, DataFilePath As String, AutoPrint As Long, FreezeWord As Long) As Long

rnWdMailMergeDocWithOptions(TemplatePath As String, DataFilePath As String, MergeSubset As Long, FromRecord As Long, ToRecord As Long, PrintBlankLines As Long, AutoPrint As Long, FreezeWord As Long) As Long

rnWdMailMergeLabels(TemplatePath As String, DataFilePath As String, AutoPrint As Long, FreezeWord As Long) As Long

rnWdMailMergeLblOptions(TemplatePath As String, DataFilePath As String, MergeSubset As Long, FromRecord As Long, ToRecord As Long, PrintBlankLines As Long, AutoPrint As Long, FreezeWord As Long) As Long

rnWdNewDocument(TemplateName As String) As Long

rnWdOpenDocument(DocumentName As String, ReadOnly As Long, Password As String, FreezeWord As Long) As Long

(1.1.5) rnWdPaste() As Long

rnWdPrintDocument(NumberOfCopies As Long) As Long

(1.1.3) rnWdProtectDocument(ProtectionType As String, Password As String) As Long

rnWdReplaceAll(StringToReplace As String, ReplacementString As String, HeaderAndFooter As Long, FreezeWord As Long) As Long

(1.1.7) rnWdReplaceBookmarkWithText(BookmarkName As String, InsertString As String, RemoveAnySplit As Long) As Long

rnWdRunMacro(MacroName As String, FreezeWord As Long) As Long

rnWdSaveDocument() As Long

rnWdSaveDocumentAs(DocumentName As String, Password As String) As Long

(1.1.3) rnWdSaveDocumentAsType(DocumentName As String, Password As String , DocumentFormat As String) As Long

(1.1.3) rnWdSetDocumentProperty(PropertyType As String , PropertyValue As String) As String

(1.1.3) rnWdSetSectionProtection(SectionNumber As Long, ProtectOn As Long) As String

(1.1.7) rnWdSetWindowViewType(ViewType As Long) As Long

(1.1.9) rnWdSpellCheckDialog(TextToCheck As String) As Long

(1.1.9) rnWdSpellCheckWord(WordToCheck As String, Delimiter As String) As Long

rnWdTemplateDocument(TemplatePath As String, DataFilePath As String, AutoPrint As Long, FreezeWord As Long) As Long

rnWdTextFileToDocument(TextFilePath As String, TemplatePath As String, PositionInDoc As String, Orientation as Long, AutoPrint As Long, FreezeWord As Long) As Long

rnWdTextFileToTable(TextFilePath As String, TemplatePath As String, PositionInDoc As String, Orientation as Long, AutosizeColumns As Long, TableBorders As Long, AutoPrint As Long, FreezeWord As Long) As Long

rnWdUnFreeze() As Long

(1.1.3) rnWdUnprotectDocument(Password As String) As Long

 

ExcelFun Functions

Latest version: 2.0

First Office 2000 compliant version: 1.1.0

First Office XP compliant version: 2.0

 

rnFindXlWindow() As Long

rnXlClearRange(RangeName As String) As Long

(1.1.13) rnXlClearRangeContents(RangeName As String) As Long

rnXlClose() As Long

rnXlCloseWorkbook(WorkbookName As String, PromptForSave As Long) As Long

rnXlCopyOrMoveSheet(SourceSheet As String, CopyOrMove As String, NewPosition As String, NewSheetName As String, FreezeExcel As Long)

rnXlCopyRange(SourceRange As String, DestinationRange As String, FreezeExcel As Long) As Long

rnXlCreateNewWorkbook(TemplateName As String, FreezeExcel As Long) As Long

rnXlDeleteRowsOrColumns(DeleteType As String, StartNumber As Long, DeleteNumber As Long, FreezeExcel As Long)

rnXlDeleteSheet(Sheet As String)

rnXlDeriveRangeName(LeftColumn As Long, TopRow As Long, RightColumn As Long, BottomRow As Long,) As String

rnXlFormatRange(RangeName As String, StyleName As String) As Long

rnXlFormatTable(RangeName As String, HeaderRow As Long, ApplyBorders As Long, AutoFitCells As Long, WrapText As Long, CellStyleName As String, HeadingStyleName As String, FreezeExcel As Long) As Long

rnXlFreeze()

rnXlGetLastErrorNumber() As Long

rnXlGetLastErrorText() As String

(1.1.5) rnXlGetNumericValueFromCell(RowNumber As Long, ColumnNumber As Long) As Variant

rnXlGetRangeBoundary(RangeName As String, BoundaryType As String) As String

rnXlGetValue(RangeName As String) As String

rnXlGetWorkbookName() As String

(1.1.23) rnXlGetWorkbookPath(IncludeFileName As Long) As String

rnXlGoto(DestinationType As String, Destination As String)

rnXlGotoR1C1Range(Top As Long, Left As Long, Bottom As Long, Right As Long)

rnXlImportTextFile(TextFilePath As String, RangeName As String, Delimiter As String, Shift As String, FreezeExcel As Long) As Long

rnXlInsertChartAsNewSheet(SourceRange As String, Gallery As Long, ChartFormat As Long, PlotBy As Long, CategoryLabels As Long, SeriesLabels As Long, HasLegend As Long, Title As String, CategoryTitle As String, ValueTitle As String, ExtraTitle As String, FreezeExcel As Long) As Long

rnXlInsertChartOnSheet(Left As Long, Top As Long, Width As Long, Height As Long, SourceRange As String, Gallery As Long, ChartFormat As Long, PlotBy As Long, CategoryLabels As Long, SeriesLabels As Long, HasLegend As Long, Title As String, CategoryTitle As String, ValueTitle As String, ExtraTitle As String, FreezeExcel As Long) As Long

(1.1.3) rnXlInsertDateValue(RangeName As String, DateValue As Date, FreezeExcel As Long)

(1.1.3) rnXlInsertDoublePrecisionValue(RangeName As String, Value As Double, FreezeExcel As Long)

(1.1.3) rnXlInsertFloatingPointValue(RangeName As String, Value As Single, FreezeExcel As Long)

(1.1.3) rnXlInsertIntegerValue(RangeName As String, Value As Long, FreezeExcel As Long)

rnXlInsertPageBreak(RangeName As String, HorizontalOrVertical As String)

(1.1.17) rnXlInsertPictureAtRange(RangeName As String, PictureFileName As String, SizeToRange As Long, FreezeExcel As Long)

rnXlInsertPivotTable(SourceRange As String, Destination As String, PivotTableName As String, RowFieldNames As String, ColumnFieldNames As String, DataFieldNames As String, PageFieldNames As String, NameDelimiter As String, ShowRowGrandTotals As Long, ShowColGrandTotals As Long, FreezeExcel As Long)

rnXlInsertRowsOrColumns(InsertType As String, StartNumber As Long, InsertNumber As Long, FreezeExcel As Long)

rnXlInsertSheet(InsertPosition As String, NewSheetName As String)

rnXlInsertValue(RangeName As String, Value As String, FreezeExcel As Long)

rnXlLaunch(WindowState As Long) As Long

(1.1.27) rnXlLaunchNewInstance(WindowState As Long) As Long

(1.1.11) rnXlMergeCells(RangeName As String) As Long

rnXlOpenWorkbook(WorkbookName As String, ReadOnly As Long, Password As String, FreezeExcel As Long) As Long

rnXlPasteRange(DestinationRange As String, FreezeExcel As Long) As Long

(1.1.15) rnXlPasteSpecialRange(DestinationRange As String, PasteType As String, SpecialOperation As String, IgnoreBlanks As Long, FreezeExcel As Long) As Long

(1.1.13) rnXlPrintRange(RangeName As String, NumberOfCopies As Long, Orientation As Long) As Long

rnXlPrintSheet(Sheet As String, NumberOfCopies As Long) As Long

rnXlPrintWorkbook(NumberOfCopies As Long) As Long

(1.1.11) rnXlProtectWorkbook(Password As String) As Long

(1.1.11) rnXlProtectWorksheet(Password As String , Contents As Long, Objects As Long, Scenarios As Long) As Long

rnXlRenameSheet(Sheet As String, NewSheetName As String) As Long

rnXlReplaceAll(StringToReplace As String, ReplacementString As String, HeaderAndFooter As Long, MatchWholeCell As Long, MatchCase As Long, FreezeExcel As Long) As Long

rnXlRunMacro(MacroName As String, NumArguments As Long, Arg1 As String, Arg2 As String, Arg3 As String, Arg4 As String, Arg5 As String, FreezeExcel As Long) As Long

rnXlSaveWorkbook(SaveAsFilePath As String, Password As String) As Long

(1.1.21) rnXlSaveWorkbookAsType(SaveAsFilePath As String, Password As String, OutputFileFormat As String, Overwrite As Long ) As Long

(1.1.21) rnXlSaveWorksheetAsType(SaveAsFilePath As String, Password As String, OutputFileFormat As String, Overwrite As Long ) As Long

(1.1.11) rnXlSetAlignment(RangeName As String, HorizontalAlignment As Long, IndentLevel As Long, VerticalAlignment As Long, WrapText As Long) As Long

(1.1.25) rnXlSetAutoCalculateOff() As Long

(1.1.25) rnXlSetAutoCalculateOn() As Long

(1.1.23) rnXlSetBackgroundColor(RangeName As String, ColorIndex As Long) As Long

(1.1.23) rnXlSetBackgroundColorRGB(RangeName As String, RGBColor As Long) As Long

(1.1.11) rnXlSetCellProtection(RangeName As String, Locked As Long, Hidden As Long) As Long

(1.1.11) rnXlSetFont(RangeName As String, FontName As String, FontSize As Long, Bold As Long, Italic As Long, Underline As Long, Strikethrough As Long, FontColor As Long) As Long

(1.1.11) rnXlSetNumberFormat(RangeName As String, FormatString As String) As Long

(1.1.21) rnXlSetRangeName(RangeName As String, LeftColumn As Long, TopRow As Long, RightColumn As Long, BottomRow As Long) As Long

(1.1.11) rnXlSetRowOrColumnSize(ObjectType As String, StartNumber As Long, NumberOfRowsOrColumns As Long, NewSize As Single) As Long

(1.1.25) rnXlSetStatusBarMessage(MessageText As String) As Long

(1.1.11) rnXlSetWindowSplit(Column As Long, Row As Long, FreezePanes As Long) As Long

(1.1.21) rnXlSortRange(RangeName As String, ByRowOrColumn As String, Key1 As String, Order1 As String, Key2 As String, Order2 As String, Key3 As String, Order3 As String, HeaderRow As Long, CaseSensitive As Long ) As Long

rnXlUnfreeze()

(1.1.11) rnXlUnprotectWorkbook(Password As String) As Long

(1.1.11) rnXlUnprotectWorksheet(Password As String) As Long

 


MailFun Functions

Latest version: 1.1.7

 

rnMlAddAttachmentFile(FilePath As String, PositionInMessage As String) As Long

rnMlAddRecipient(Name As String, Address As String, RecipientType As String) As Long

(1.1.5) rnMlGetAddressForDisplayName(DisplayNameSearchString As String, Delimiter As String, ShowResolveDialogForConflicts As Long) As String

rnMlGetLastErrorNumber() As Long

rnMlGetLastErrorText() As String

(1.1.5) rnMlGetRecipientList(Delimiter As String) As String

rnMlNewMessage(Subject As String, MessageText As String) As Long

rnMlQuickSendMessage(Name As String, Address As String, Subject As String, MessageText As String) As Long

rnMlSendMessage(ViewBeforeSend As Long) As Long

(1.1.5) rnMlShowAddressBook(EditFieldCount As Long, Caption As String) As Long

(1.1.7) rnMlStartNewSession(UserName As String, Password As String, PromptForLogon As Long) As Long

rnMlStartSession(UserName As String, Password As String, PromptForLogon As Long) As Long

rnMlStopSession() As Long