T Tom Oct 23, 2003 #1 Hi Is it possible to call the TextImportWizard with vba? If yes, how to do? Tom
D Dave Peterson Oct 24, 2003 #2 I think you could open a text file and import it to only column A. Then show that dialog. Option Explicit Sub testme() Dim myFileName As Variant myFileName = Application.GetOpenFilename("Text files, *.txt") If myFileName = False Then Exit Sub End If Workbooks.Open Filename:=myFileName Range("a:a").Select Application.Dialogs(xlDialogTextToColumns).Show End Sub
I think you could open a text file and import it to only column A. Then show that dialog. Option Explicit Sub testme() Dim myFileName As Variant myFileName = Application.GetOpenFilename("Text files, *.txt") If myFileName = False Then Exit Sub End If Workbooks.Open Filename:=myFileName Range("a:a").Select Application.Dialogs(xlDialogTextToColumns).Show End Sub