TextToColumns Dialog

Howie · Oct 28, 2003

Anyone know how to invoke the textToColumns dialog box,
and whether you can capture the info that the user
supplies to the dialog?

Tom Ogilvy · Oct 28, 2003

The only way to capture the information is to use the macro recorder.

application.Dialogs(xlDialogTextToColumns).Show