Automated Text Import in Excel with File Selection - The Easy Way - VBA

Add to Favorites
Author: | Edits: don

Full VBA/Macro Course

How to import a text or csv file into Excel using an automated macro and vba - this is the easier, yet robust, way to import text using a macro.

This tutorial teaches you how to import text using a macro with a file selection popup window that lets the uer choose the file to import and also using a predefined file name so that you can quickly import the file without having to choose it from the computer.

All code in this tutorial is commented and fully explained and I take you step-by-step through the process of building the import macro and showing you how to change it to meet your needs.

This tutorial combines many features, including:

  • GetOpenFilename()¬†
  • OpenText¬†
  • IF Statements in VBA
  • Copying values between workbooks in Excel.

 


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)