Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


How to start Text Import Wizard in Excel 97 macro?

Posted on 1999-07-21
Medium Priority
Last Modified: 2008-03-10
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.
Question by:saidah
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Author Comment

ID: 1609761
Edited text of question.

Accepted Solution

cartti earned 400 total points
ID: 1609762
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.

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question