View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ehz2101@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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!