View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Text Import Wizard from vba

You could try this:

Application.Dialogs(xlDialogImportTextFile).Show

--
Jim
"Ömer Ayzan" wrote in message
...
| Friends I am a Office 2000 user. Is there a way to call the text import
| wizard from vba so that when importing text that is started from a code,
the
| user presented with the wizard first enabling him/her to set field
lengths.
|
| Thanks in advance
|
|