H
Howie
Still trying to call the textToColumns wizard. The
documented argument list is:
destination_ref, data_type, text_delim, consecutive_delim,
tab, semicolon, comma, space, other, other_char, field_info
Get "No data was selected to parse" message when executing
code below. Could be the field_info, although I'm not
really sure what they are looking for there. Thanks for
any ideas.
Public Sub textToColumnsWiz()
With Application.Dialogs(xlDialogTextToColumns)
rc = .Show(Range("H19"), xlDelimited,
xlDoubleQuote, False, False, False, True, False, False,
Array(1, 2, 3))
End With
End Sub
documented argument list is:
destination_ref, data_type, text_delim, consecutive_delim,
tab, semicolon, comma, space, other, other_char, field_info
Get "No data was selected to parse" message when executing
code below. Could be the field_info, although I'm not
really sure what they are looking for there. Thanks for
any ideas.
Public Sub textToColumnsWiz()
With Application.Dialogs(xlDialogTextToColumns)
rc = .Show(Range("H19"), xlDelimited,
xlDoubleQuote, False, False, False, True, False, False,
Array(1, 2, 3))
End With
End Sub