Text Import Wizard from vba

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" <omerayzan@ayz.com.tr> wrote in message
news:OZh$2F5OFHA.2532@TK2MSFTNGP09.phx.gbl...
| 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" <jrrech@hotmail.com> wrote in message
news:OdTgLo5OFHA.2704@TK2MSFTNGP15.phx.gbl...
> You could try this:
>
> Application.Dialogs(xlDialogImportTextFile).Show
>
> --
> Jim
> "Ömer Ayzan" <omerayzan@ayz.com.tr> wrote in message
> news:OZh$2F5OFHA.2532@TK2MSFTNGP09.phx.gbl...
> | 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
> |
> |
>
>