# 51 - Course macros and Excel VBA - Project 1 - Import Text File
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 pr...
Lesson 2 - First macro: configure automatically page
• #02 - Macros e Excel VBA - Aprenda a ...
Class 3 - Types of macros: Relative or Absolute
• #03 - Curso de Macros e Excel VBA - R...
Lesson 4 - Associating macros buttons
• #04 - Curso de Macros e Excel VBA - B...
Lesson 5 - Macro Security
• #05 - Curso de Macros e Excel VBA - S...
Lesson 6 - Registration Client - Model 1
• #06 - Macros e Excel VBA - Curso Grát...
Lesson 7 - Registration Client - Version 2
• #07 - Macros e Excel VBA - Cadastro d...
Lesson 8 - Combo Box - Form Control
• #08 - Macros e Excel VBA - Caixa de C...
Lesson 9 - Checkbox and Radio Button - Form Control
• #09 - Macros e Excel VBA - Caixa de S...
Lesson 10 - List Box and Spin Button - Form Control
• #10 - Macros e Excel VBA - Controle d...
L11 - Start of VBA programming activities
• #11 - Macros e Excel VBA - Começando ...
Lesson 12 - Events (Activate, Calculate), comment code, RANGE instruction and Verification Immediate
• #12 - Macros e Excel VBA - Eventos e ...
Lesson 13 - Variables in VBA
• #13 - Macros e Excel VBA - Tipos e Us...
Lesson 14 - Variables in Visual Basic for Applications (continued)
• #14 - Macros e VBA - Excel - Tipos de...
Class 15 - Repetition structure - DO WHILE ... LOOP
• #15 - Macros e Excel VBA - Do While -...
Lesson 16 - Repetition structure - DO WHILE ... LOOP (reverse)
• #16 - Curso de Macros e Excel VBA - D...
Lesson 17 - Repetition structure - DO UNTIL ... LOOP
• #17 - Curso de Macros e Excel VBA - D...
Lesson 18 - Repeat structure with criteria - IF Function
• #18 - Curso de Macros e Excel VBA - I...
Lesson 19 - Repetition structure - FOR NEXT
• #19 - Curso de Macros e Excel VBA - F...
Lesson 20 - Repetition structure - FOR NEXT STEP ...
• #20 - Curso de Macros e Excel VBA - F...
Lesson 21 - Repetition structure - FOR EACH ... NEXT
• #21 - Curso de Macros e Excel VBA - F...
Lesson 22 - Repetition structure - FOR EACH ... NEXT - With the user password prompt
• #22 - Curso de Macros e Excel VBA - E...
Lesson 23 - Registering opening and closing sheet (using the Environ statement)
• #23 - Curso de Macros e Excel VBA - E...
Lesson 24 - Blocking access to a spreadsheet for login
• #24 - Curso de Macros e Excel VBA - R...
Lesson 25 - Error Handling - On Error GoTo
• #25 - Curso de Macros e Excel VBA - T...
Lesson 26 - Delete records from a register
• #26 - Curso de Macros e Excel VBA - A...
Lesson 27 - Change records of a record
• #27 - Curso de Macros e Excel VBA - A...
Lesson 28 - Manipulating several spreadsheets: Delete data, Hide and unhide
• #28 - Curso de Macros e Excel VBA - M...
Lesson 29 - Identifying duplicate records in more than one sheet
• #29 - Curso de Macros e Excel VBA - I...
Lesson 30 - Generating combinations of numbers (no repetition)
• #30 - Curso de Macros e Excel VBA - G...
Lesson 31 - Generating combinations of groups (without repetition)
• #31 - Curso de Macros e Excel VBA - G...
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
