# 51 - Course macros and Excel VBA - Project 1 - Import Text File

Опубликовано: 11 Апрель 2026
на канале: Alessandro Trovato

12,159

456

In this fifty-first session of the course macros and VBA will complete the project to import text files teaching you how to perform the final formatting of the text.

final shape of the project

- How to format the data after processing
- Using the macro recorder to discover formatting,
- Finish design with formatting.

I hope you enjoy the content.
If you like to share with your co-workers and friends!

************************************************** *************
complete course of Advanced Excel Online. Go!
http://curseduca.com/136-microsoft-ex...
************************************************** *************

Access spreadsheets:
www.sigaonerd.com

OTHER COURSE CLASSES

Lesson 1 - Introduction to Course and description of what is a macro
   • #01 - Macros Excel VBA - Aprenda a programar

Lesson 2 - First macro: configure automatically page
   • #02 - Macros e Excel VBA - Aprenda a progr...

Class 3 - Types of macros: Relative or Absolute
   • #03 - Curso de Macros e Excel VBA - Referê...

Lesson 4 - Associating macros buttons
   • #04 - Curso de Macros e Excel VBA - Botões...

Lesson 5 - Macro Security
   • #05 - Curso de Macros e Excel VBA - Segurança

Lesson 6 - Registration Client - Model 1
   • #06 - Macros e Excel VBA - Curso Grátis e ...

Lesson 7 - Registration Client - Version 2
   • #07 - Macros e Excel VBA - Cadastro de Cli...

Lesson 8 - Combo Box - Form Control
   • #08 - Macros e Excel VBA - Caixa de Combin...

Lesson 9 - Checkbox and Radio Button - Form Control
   • #09 - Macros e Excel VBA - Caixa de Seleçã...

Lesson 10 - List Box and Spin Button - Form Control
   • #10 - Macros e Excel VBA - Controle de For...

L11 - Start of VBA programming activities
   • #11 - Macros e Excel VBA - Começando a pro...

Lesson 12 - Events (Activate, Calculate), comment code, RANGE instruction and Verification Immediate
   • #12 - Macros e Excel VBA - Eventos e Instr...

Lesson 13 - Variables in VBA
   • #13 - Macros e Excel VBA - Tipos e Uso de ...

Lesson 14 - Variables in Visual Basic for Applications (continued)
   • #14 - Macros e VBA - Excel - Tipos de Vari...

Class 15 - Repetition structure - DO WHILE ... LOOP
   • #15 - Macros e Excel VBA - Do While - Loop

Lesson 16 - Repetition structure - DO WHILE ... LOOP (reverse)
   • #16 - Curso de Macros e Excel VBA - Do Whi...

Lesson 17 - Repetition structure - DO UNTIL ... LOOP
   • #17 - Curso de Macros e Excel VBA - Do Unt...

Lesson 18 - Repeat structure with criteria - IF Function
   • #18 - Curso de Macros e Excel VBA - IF The...

Lesson 19 - Repetition structure - FOR NEXT
   • #19 - Curso de Macros e Excel VBA - For Next

Lesson 20 - Repetition structure - FOR NEXT STEP ...
   • #20 - Curso de Macros e Excel VBA - For Ne...

Lesson 21 - Repetition structure - FOR EACH ... NEXT
   • #21 - Curso de Macros e Excel VBA - For ea...

Lesson 22 - Repetition structure - FOR EACH ... NEXT - With the user password prompt
   • #22 - Curso de Macros e Excel VBA - Estrut...

Lesson 23 - Registering opening and closing sheet (using the Environ statement)
   • #23 - Curso de Macros e Excel VBA - Enviro...

Lesson 24 - Blocking access to a spreadsheet for login
   • #24 - Curso de Macros e Excel VBA - Restri...

Lesson 25 - Error Handling - On Error GoTo
   • #25 - Curso de Macros e Excel VBA - Tratam...

Lesson 26 - Delete records from a register
   • #26 - Curso de Macros e Excel VBA - Apagar...

Lesson 27 - Change records of a record
   • #27 - Curso de Macros e Excel VBA - Altera...

Lesson 28 - Manipulating several spreadsheets: Delete data, Hide and unhide
   • #28 - Curso de Macros e Excel VBA - Manipu...

Lesson 29 - Identifying duplicate records in more than one sheet
   • #29 - Curso de Macros e Excel VBA - Identi...

Lesson 30 - Generating combinations of numbers (no repetition)
   • #30 - Curso de Macros e Excel VBA - Gerar ...

Lesson 31 - Generating combinations of groups (without repetition)
   • #31 - Curso de Macros e Excel VBA - Gerar ...

Visit the address below to access later lessons ... (It is not over here in the description!)
http://sigaonerd.esy.es/index.html

Youtube channel confirmation link
   / @alessandrotrovato

Follow us on Facebook or Twitter
  / sigaonerdpontocom
  / aletrovato

Microsoft Excel is a Microsoft Office suite application