TextToColumns dialog box - argument settings

[jeffreypaul]

In VBA, is it possible to check the current argument settings for the 'Text to Columns' dialog box before opening it for the user?

Specifically, is the Delimited 'Other:' box checked and what 'other_char:' is used?

Alernately, is there a way to get to the 3rd dialog box of the 'Text to Columns' dialog box when using Application.Dialogs(xlDialogTextToColumns).Show?
I would like to show the user the dialog box at 'Step 3 of 3' for a delimited selection, and not make the user click 'Next' twice.

Thanks for the help

 

[RobBroekhuis]

I think you'll be better off getting the delimiter information from your own custom userform, so that you can save the user's default values in your own variables. Besides not wanting to recreate forms that already exist, is there a reason why you want to reuse Excel's existing dialog?


Rob

 

[jeffreypaul]

Creating a custom userform would allow me to control the options, but how do you simulate the 'Step 3 of 3' dialog box 'Data Preview' window? The user must be able to select the 'Column Data Format:' for each column (which changes for each different import)?