QueryTable.TextFileTrailingMinusNumbers Property

Syntax

expression.TextFileTrailingMinusNumbers

expression A variable that represents a QueryTable object.

Example

In this example, Microsoft Excel determines the setting for cell A1, treating numbers imported as text that begin with a "-" symbol. This example assumes a QueryTable object exists on the active worksheet.

Visual Basic for Applications

Visual Basic for Applications
`Sub CheckQueryTableSetting() ' Determine setting for TextFileTrailingMinusNumbers If Range("A1").QueryTable.TextFileTrailingMinusNumbers = True Then MsgBox "Numbers imported as text that begin with a '-' symbol " & _ "will be treated as a negative symbol." Else MsgBox "Numbers imported as text that begin with a '-' symbol " & _ "will not be treated as a negative symbol." End If End Sub`

Sub CheckQueryTableSetting() ' Determine setting for TextFileTrailingMinusNumbers If Range("A1").QueryTable.TextFileTrailingMinusNumbers = True Then MsgBox "Numbers imported as text that begin with a '-' symbol " & _ "will be treated as a negative symbol." Else MsgBox "Numbers imported as text that begin with a '-' symbol " & _ "will not be treated as a negative symbol." End If End Sub

text text file trailing minus numbers textfile textfiletrailing textfiletrailingminus textfiletrailingminusnumbers textfiletrailingminusnumbers property

See also: