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!

Hi EHZ,

Try:

Application.Dialogs(xlDialogTextToColumns).Show

---
Regards,
Norman


wrote in message
oups.com...
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!

Hi ehz,

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

Thanks
Regards,
Howard

wrote in message
oups.com...
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!

Forgot, here's my e-mail..

Thanks
Howard

wrote in message
oups.com...
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!

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

-Eric Zhang