Context: |
Class Method (Function) |
Library/Class: |
FileExport Class |
Function FileExport.XlsDialog() As Integer
XlsDialog (stats As staticvars, dlgnum As Integer)
This is a generic method to call Excel dialogs using the Excel application object class (stats.XlsAppl.Dialogs(dlgnum).Show). The method processes the following steps:
- disables the Integra progress bar
- activates the Excel application (makes it visible)
- calls the Excel dialog as specified in the dlgnum parameter
- hides the Excel application
- enables the Integra progress bar
The method can be used to call any of the available Excel dialogs, however, Integra is using only two dialogs: the file print dialog and the file save as dialog. Unlike for the WordDialog method, no constants are defined for these two used dialogs.
Parameters:
Handle to Integra's runtime object stats
dlgnum (Integer)
(Index-) Number of the Excel dialog
Return Value:
Passes on the return value of stats.XlsAppl.Dialogs(dlgnum).Show.
|