Video Use Text Import Wizard. The wizard is also available on the Data tab of the Ribbon using the From Text button. As shown below choose Data and.
To switch the Text Import Wizard back on. WorkbooksnameConnectionsAddFromFile datacsv True False. Go to Data Get External Data From Text and open that file.
I had never done a data connection through vba so I have only tried to record the Macro generating the following code.
Then in the Import Text File dialog box double-click the text file that you want to import and the Text Import Wizard dialog will open. Some of my text entries are rather lengthy. Click on the Options button. Click on FILE then.