Create and perform a link between a spreadsheet or database and the current document.
ImportDoUpdate
Syntax
ImportDoUpdate()
Description
Update linked data in the current document to match the data in linked spreadsheet or database files.
ImportEditDlg
Syntax
ImportEditDlg()
Description
Display the Edit Data Link dialog box.
ImportOptionsDlg
Syntax
ImportOptionsDlg()
Description
Display the Link Options dialog box.
ImportSetAsciiEncap
Syntax
ImportSetAsciiEncap(EncapsulationChar As String)
Description
Specify an ASCII encapsulation character for importing spreadsheet or database data saved as ASCII delimited text.
Parameters
EncapsulationChar: string The ASCII encapsulation character.
ImportSetAsciiFieldDelimiter
Syntax
ImportSetAsciiFieldDelimiter(FieldDelimiter As String)
Description
Specify the characters to mark the beginning or end of a field when importing spreadsheet or database data saved as ASCII delimited text.
Parameters
FieldDelimiter: string The ASCII field delimiter.
ImportSetAsciiRecordDelimiter
Syntax
ImportSetAsciiRecordDelimiter(RecordDelimiter As String)
Description
Specify the characters to mark the beginning or end of a record when importing spreadsheet or database data saved as ASCII delimited text.
Parameters
RecordDelimiter: string The ASCII record delimiter.
ImportSetAsciiStrip
Syntax
ImportSetAsciiStrip(StripChars As String)
Description
Delete extra characters when importing spreadsheet or database data saved as ASCII delimited text.
Parameters
StripChars: string Characters to delete when importing ASCII text.
ImportSetDataSource
Syntax
ImportSetDataSource(Source As String)
Description
Specify the data source for an ODBC import.
Parameters
Source: string The filename and location of a data file.
ImportSetDestination
Syntax
ImportSetDestination(DestinationType As _ImportSetDestination_DestinationType_enum)
Description
Specify a format for linked or imported spreadsheet or database data.
Parameters
DestinationType: enumeration MergeData!
TabbedText!
WPTable!
ImportSetDictPath
Syntax
ImportSetDictPath(DictionaryPath As String)
Description
Specify the Novell NetWare SQL dictionary path for imported spreadsheet or database data. Available only for Pioneer Q+E drivers.
Parameters
DictionaryPath: string The SQL dictionary path.
ImportSetFields
Syntax
ImportSetFields(FieldNames As String)
Description
Specify the database fields to import.
Parameters
FieldNames: string Separate fields with a comma, enclosed in quotation marks.
ImportSetFileName
Syntax
ImportSetFileName(Filename As String)
Description
Specify a source file to link to or import from.
Parameters
Filename: string The filename of the source file.
ImportSetFilePath
Syntax
ImportSetFilePath(FilePath As String)
Description
Specify a NetWare SQL file path. Available only for Pioneer Q+E drivers.
Parameters
FilePath: string The path to the SQL file.
ImportSetFirstRecFieldNames
Syntax
ImportSetFirstRecFieldnames(State As _ImportSetFirstRecFieldnames_State_enum)
Description
Lets you specify whether or not to set the first record as field names.
Parameters
State: enumeration No!
Yes!
ImportSetIncludeNames
Syntax
ImportSetIncludeNames(State As _ImportSetIncludeNames_State_enum)
Description
Use the field names as headings for imported database data.
Parameters
State: enumeration Off!
On!
ImportSetPanel
Syntax
ImportSetPanel(PanelName As String)
Description
Specify a Corel DataPerfect panel to retrieve.
Parameters
PanelName: string The name of the panel.
ImportSetPassword
Syntax
ImportSetPassword(Password As String)
Description
Specify a password to import SQL data. Available only for Pioneer Q+E drivers.
Parameters
Password: string The password for SQL data.
ImportSetQuery
Syntax
ImportSetQuery([FieldName1 As String], [FieldName2 As String], [FieldName3 As String], [Condition1Field1 As String], [Condition1Field2 As String], [Condition1Field3 As String], [Condition2Field1 As String], [Condition2Field2 As String], [Condition2Field3 As String], [Condition3Field1 As String], [Condition3Field2 As String], [Condition3Field3 As String], [Condition4Field1 As String], [Condition4Field2 As String], [Condition4Field3 As String])
Description
Specify the field conditions for a database import query. For examples of valid conditions, choose Example from the Define Selection Conditions dialog box.
Parameters
FieldName1: string (optional) The name of the first field.
FieldName2: string (optional) The name of the second field.
FieldName3: string (optional) The name of the third field.
Specify a server for a NetWare SQL database import. Available only for Pioneer Q+E drivers.
Parameters
ServerName: string The name of the SQL server.
ImportSetSizeToFit
Syntax
ImportSetSizeToFit(State As _ImportSetSizeToFit_State_enum)
Description
Size table columns to fit data after it is imported.
Parameters
State: enumeration No!
Yes!
ImportSetSource
Syntax
ImportSetSource(SourceType As _ImportSetSource_SourceType_enum)
Description
Specify the format of spreadsheet or database data to import.
Parameters
SourceType: enumeration ANSIText!
ASCII!
Clipper!
DataPerfect!
DB2!
dBase!
FoxPro!
InFormix!
NetWare!
ODBC!
ODBC_NO_SQL!
Oracle!
Paradox!
Spreadsheet!
SQLBase!
SQLServer!
Sybase!
XDB!
ImportSetSQLQuery
Syntax
ImportSetSQLQuery(SQLQuery As String)
Description
Specify the conditions for a database link or import query. For examples of valid conditions, choose Example from the Define Selection Conditions dialog box.
Parameters
SQLQuery: string The conditions for a database link or import query.
ImportSetTable
Syntax
ImportSetTable(TableName As String)
Description
Specify a table to import.
Parameters
TableName: string The name of the table to import.
ImportSetUserID
Syntax
ImportSetUserID(UserId As String)
Description
Specify a NetWare SQL database user identification. Available only for Pioneer Q+E drivers.
Parameters
UserId: string The SQL user identification.
ImportUpdateDlg
Syntax
ImportUpdateDlg()
Description
Display the Update import dialog box.
Indent
Syntax
Indent()
Description
Indent a paragraph one tab stop to the right without changing the margins.
IndentLeftRight
Syntax
IndentLeftRight()
Description
Indent both sides of a paragraph equally from the left and right margin.
IndexDefineDlg
Syntax
IndexDefineDlg()
Description
Display the Define Index dialog box.
IndexDefinition
Syntax
IndexDefinition(Heading, SubHeading, NumMode As _IndexDefinition_NumMode_enum, PgCombine As _IndexDefinition_PgCombine_enum, [Concordance As String], [UserFormat As String])
Description
Create and insert an index definition. You must pass thre numeric for the Heading and the SubHeading.
Parameters
Heading: any NormalStyle!
FootnoteNumberInDocumentStyle!
EndnoteNumberInDocumentStyle!
FigureNumberStyle!
TableBoxNumberStyle!
TextBoxNumberStyle!
UserBoxNumberStyle!
EquationNumberStyle!
HypertextStyle!
ToC1Style!
ToC2Style!
ToC3Style!
ToC4Style!
ToC5Style!
Index1Style!
Index2Style!
ListStyle!
ToAStyle!
DocStyle!
BoxTextStyle!
CaptionStyle!
FootnoteStyle!
EndnoteStyle!
CommentStyle!
HeaderAStyle!
HeaderBStyle!
FooterAStyle!
FooterBStyle!
WatermarkAStyle!
WatermarkBStyle!AddressStyle!
ParagraphOutlnStyle!
OutlineStyle!
LegalOutlnStyle!
BulletsOutlnStyle!
HeadingsOutlnStyle!
Legal_2OutlnStyle!
NumbersOutlnStyle!
Level1Style!
Level2Style!
Level3Style!
Level4Style!
Level5Style!
Level6Style!
Level7Style!
Level8Style!
Legal1Style!
Legal2Style!
Legal3Style!
Legal4Style!
Legal5Style!
Legal6Style!
Legal7Style!
Legal8Style!
Heading1Style!
Heading2Style!
Heading3Style!
Heading4Style!
Heading5Style!
Heading6Style!
Heading7Style!
Heading8Style!
MonospacedStyle!
CustomHTMLStyle!
PreformattedStyle!
AddressStyle!
QuotationsOutlnStyle!
DefinitionsOutlnStyle!
Quotation1Style!
Quotation2Style!
Quotation3Style!
Quotation4Style!
Quotation5Style!
Quotation6Style!
Quotation7Style!
Quotation8Style!
Definition1Style!
Definition2Style!
Definition3Style!
Definition4Style!
Definition5Style!
Definition6Style!
Definition7Style!
Definition8Style!
Level9Style!
Legal9Style!
Heading9Style!
Quotation9Style!
DefinitionStyle! ! 0
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
111
112
113
115
116
Any The subheading style
NormalStyle!
FootnoteNumberInDocumentStyle!
EndnoteNumberInDocumentStyle!
FigureNumberStyle!
TableBoxNumberStyle!
TextBoxNumberStyle!
UserBoxNumberStyle!
EquationNumberStyle!
HypertextStyle!
ToC1Style!
ToC2Style!
ToC3Style!
ToC4Style!
ToC5Style!
Index1Style!
Index2Style!
ListStyle!
ToAStyle!
DocStyle!
BoxTextStyle!
CaptionStyle!
FootnoteStyle!
EndnoteStyle!
CommentStyle!
HeaderAStyle!
HeaderBStyle!
FooterAStyle!
FooterBStyle!
WatermarkAStyle!
WatermarkBStyle!AddressStyle!
ParagraphOutlnStyle!
OutlineStyle!
LegalOutlnStyle!
BulletsOutlnStyle!
HeadingsOutlnStyle!
Legal_2OutlnStyle!
NumbersOutlnStyle!
Level1Style!
Level2Style!
Level3Style!
Level4Style!
Level5Style!
Level6Style!
Level7Style!
Level8Style!
Legal1Style!
Legal2Style!
Legal3Style!
Legal4Style!
Legal5Style!
Legal6Style!
Legal7Style!
Legal8Style!
Heading1Style!
Heading2Style!
Heading3Style!
Heading4Style!
Heading5Style!
Heading6Style!
Heading7Style!
Heading8Style!
MonospacedStyle!
CustomHTMLStyle!
PreformattedStyle!
AddressStyle!
QuotationsOutlnStyle!
DefinitionsOutlnStyle!
Quotation1Style!
Quotation2Style!
Quotation3Style!
Quotation4Style!
Quotation5Style!
Quotation6Style!
Quotation7Style!
Quotation8Style!
Definition1Style!
Definition2Style!
Definition3Style!
Definition4Style!
Definition5Style!
Definition6Style!
Definition7Style!
Definition8Style!
Level9Style!
Legal9Style!
Heading9Style!
Quotation9Style!
DefinitionStyle!
0
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
111
112
113
114
115
NumMode: enumeration The page numbering method after a heading.
DefFlushRight!
DefFollows!
DefLeader!
DefNone!
DefParentheses!
PgCombine: enumeration Combine sequential page numbers (for example, 51-53) or not (51, 52, 53).
Combine!
NoCombine!
Concordance: string (optional) The concordance format.
UserFormat: string (optional) The page number format. Default: document format.
IndexMark
Syntax
IndexMark([Heading As String], [SubHeading As String])
Description
Mark the text to be indexed. You can specify both a heading and a subheading.
Parameters
Heading: string (optional) The heading for the index entry.
Subheading: string (optional) The subheading for the index entry.
InhibitInput
Syntax
InhibitInput([State As _InhibitInput_State_enum]) As Boolean
Description
Enable or disable keyboard and menu input during macro execution.
Return Value
Returns True if Inhibit Input is active, False if not. If the State parameter is omitted, its current value is returned. If it is included, the current value is returned, then the new value is set.
Parameters
State: enumeration (optional) Off!
On!
InitialCodesDoc
Syntax
InitialCodesDoc()
Description
Begin initial codes. All codes between InitialCodesDoc and SubstructureExit are placed in initial codes.
InitialCodesStyleDlg
Syntax
InitialCodesStyleDlg()
Description
Display the Styles Editor dialog box. Recordable equivalent: Format, Document, Initial Codes Style.
InsertDefaultBullet
Syntax
InsertDefaultBullet()
Description
Insert another bullet or number of the last type inserted.
InsertFilename
Syntax
InsertFilename()
Description
Insert the filename of the current document.
InsertFilenameWithPath
Syntax
InsertFilenameWithPath()
Description
Insert the path and filename of the current document.
InsertOtherCodesDlg
Syntax
InsertOtherCodesDlg()
Description
Display the Other Codes dialog box.
InternetPublisherDlg
Syntax
InternetPublisherDlg()
Description
Display the Internet Publisher dialog box.
InvokeDialog
Syntax
InvokeDialog(Dialog As Integer)
Description
Display a specified dialog box but do not pause the macro for input.
Parameters
Dialog: method name The dialog box to display.
IrregularCap
Syntax
IrregularCap(State As _IrregularCap_State_enum)
Description
Corrects two consecutive uppercase letters followed by a lowercase letter at the beginning of a word. The second uppercase letter is made lowercase.
Parameters
State: enumeration Off!
On!
IsTokenValid
Syntax
IsTokenValid(Variable, Token As Integer) As Boolean
Description
Indicate whether a specified macro method can be executed given the current state of the program. For example, when the Clipboard is empty, the EditPaste method is invalid. This method is equivalent to checking whether an option grayed is in the interface. Menu items and dialog boxes are represented by the macro methods that execute them. For example, to check the Open dialog, use FileOpenDlg.
Return Value
Returns True if the token specified in the Token parameter is valid, False if not.
Parameters
Variable: variable The value of the variable specified in this parameter is set to True if token specified in the Token parameter is available, False if not.
Token: method name The macro method (token) specifying item or dialog to check.