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

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
|
|

Thank you jim it serves the purpose. Is there a way also to get the field
lengths of the file which is opened by this wizard so that we can save it
into a file and next time user can choose whether to use the wizard or the
saved lengths to open the text file
regards,
ömer
"Jim Rech" wrote in message
...
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
|
|