| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 TeachExcel | 2021-02-16 13:00:04 |  148,170 Views |
200+ Video Tutorials – 200+ Downloadable Excel Reference Files – 50+ Hours of Content
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, with user-selected files or hardcoded file names.
Excel File: https://www.teachexcel.com/excel-tutorial/2401/automated-text-import-in-excel-the-easy-way-vba?nav=yt
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt
This tutorial teaches you how to import text using a macro with a file selection popup window that lets the user 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 VBA features, including:
– GetOpenFilename()
– OpenText
– IF Statements in VBA
– Copying values between workbooks in Excel.
Excel Courses:
– VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php
– Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_L_EzUTK5hhjWM
TeachExcel.com
#msexcel #howto #tutorial
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
