How to start Text Import Wizard in Excel 97 macro?

I'd need to start Text Import Wizard from my macro in Excel
97. This wizard is started in Excel after choosing a text file to open. There is OpenText function in VB for Excel,
but after calling it, the Wizard doesn't appear and the
file is opened without user interaction.
Who is Participating?
carttiConnect With a Mentor Commented:
I don't believe it's possible to have the Text Import Wizard appear when running in code. You will have to use the parameters of OpenText to do what the user would normally do to open the file. If you still want the user to manually delimit the file, I suggest you build a user form for the interface that does this process. If you require help in this, I will give it to you.
saidahAuthor Commented:
Edited text of question.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.