TextToColumns prompt
 

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!

TextToColumns prompt
 

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!

TextToColumns prompt
 

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!

TextToColumns prompt
 

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!

TextToColumns prompt
 

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

-Eric Zhang