Text Import Wizard from vba

  • Thread starter Thread starter Ömer Ayzan
  • Start date Start date
Ö

Ömer Ayzan

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
| 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Easy Steps to Import PST Files to Office 365 0
import Excel worksheet to SQL Server table 7
Importing Text Files Into Access 1
Import txt file with fixed length from VBA 3
Which is the best MBOX Converter Tool different formats conversion? 4
Opening .xls files 2
Date formatting in VBA 1
Text import wizard bug 8

Back
Top