xlDialogTextToColumns arguments

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top