View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Howie[_3_] Howie[_3_] is offline
external usenet poster
 
Posts: 5
Default xlDialogTextToColumns arguments

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