TextToColumns prompt

[ehz2101]

Hi, I'm trying to write a 'wizard' to help a user parse a text file,
and I'd like to use the TextToColumns functionality built into Excel.
It seems, however, that when you call TextToColumns programmatically,
it will do it immediately with the parameters specified in the code.
Is it possible to pop up the TextToColumns dialog box from code, and
have the user enter different parameters for each run? Thanks!

 

[Norman Jones]

Hi EHZ,

Try:

Application.Dialogs(xlDialogTextToColumns).Show

 

[L. Howard Kittle]

Hi ehz,

Would you mind sharing your final code that does that. Very interesting.

Thanks
Regards,
Howard

 

[L. Howard Kittle]

Forgot, here's my e-mail.. (e-mail address removed)

Thanks
Howard

 

[ehz2101]

Thanks for the tip, I'll try it asap.

-Eric Zhang