VBA Fundamentals [2013, ENG]

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

VBA Fundamentals

Год выпуска: 2013
Производитель: Pluralsight
Автор: Terry Bradbury
Продолжительность: 3h 38m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание:
Этот курс поможет разработчикам любого уровня познакомиться с VBA.

This course will help developers of any level get the most out of the Visual Basic for Applications (VBA) environment.
Starting with the development environment and working through various aspects of the language, you will learn the tools and techniques needed to build custom solutions for Microsoft Office.
[spoiler="Содержание"]
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Introduction 8.48 MB 0:05:24 ‎128kbps 223.00 1024x768 ‎15 frames/second 01.Introduction to VBA Fundamentals
01.Introduction 2.07 MB 0:01:35 ‎128kbps 97.00 1024x768 ‎15 frames/second 02.The VBA Environment
02.Configuring for Development 11.9 MB 0:03:35 ‎128kbps 924.00 1024x768 ‎15 frames/second 02.The VBA Environment
03.The Developer Tab 18.8 MB 0:05:51 ‎128kbps 973.00 1024x768 ‎15 frames/second 02.The VBA Environment
04.Macro Security 5.11 MB 0:02:06 ‎128kbps 1041.00 1024x768 ‎15 frames/second 02.The VBA Environment
05.The Visual Basic Editor - The Macro Recorder 13.9 MB 0:06:04 ‎128kbps 841.00 1024x768 ‎15 frames/second 02.The VBA Environment
06.The Visual Basic Editor - The Standard Toolbar 9.35 MB 0:02:39 ‎128kbps 1276.00 1024x768 ‎15 frames/second 02.The VBA Environment
07.The Visual Basic Editor - The Project Explorer 8.37 MB 0:04:01 ‎128kbps 762.00 1024x768 ‎15 frames/second 02.The VBA Environment
08.The Visual Basic Editor - The Properties Window 1.48 MB 0:00:49 ‎128kbps 198.00 1024x768 ‎15 frames/second 02.The VBA Environment
09.The Visual Basic Editor - The Editor Window 9.34 MB 0:03:13 ‎128kbps 1265.00 1024x768 ‎15 frames/second 02.The VBA Environment
10.The Visual Basic Editor - The Edit Toolbar 3.13 MB 0:01:52 ‎128kbps 186.00 1024x768 ‎15 frames/second 02.The VBA Environment
11.The Visual Basic Editor - The UserForm Toolbar 11.6 MB 0:04:47 ‎128kbps 607.00 1024x768 ‎15 frames/second 02.The VBA Environment
12.The Object Browser 3.41 MB 0:01:47 ‎128kbps 341.00 1024x768 ‎15 frames/second 02.The VBA Environment
13.The Debugger - The Debug Toolbar 7.74 MB 0:04:37 ‎128kbps 479.00 1024x768 ‎15 frames/second 02.The VBA Environment
14.The Debugger - The Immediate Window 1.77 MB 0:01:03 ‎128kbps 237.00 1024x768 ‎15 frames/second 02.The VBA Environment
15.The Debugger - The Locals Window 1.02 MB 0:00:36 ‎128kbps 152.00 1024x768 ‎15 frames/second 02.The VBA Environment
16.The Debugger - The Watch Window 1.33 MB 0:00:42 ‎128kbps 220.00 1024x768 ‎15 frames/second 02.The VBA Environment
17.The Debugger - The Call Stack 765 KB 0:00:22 ‎128kbps 162.00 1024x768 ‎15 frames/second 02.The VBA Environment
18.The Debugger - Compiling Code 1.44 MB 0:00:45 ‎128kbps 168.00 1024x768 ‎15 frames/second 02.The VBA Environment
19.Developer Add-Ins 16.6 MB 0:05:36 ‎128kbps 1164.00 1024x768 ‎15 frames/second 02.The VBA Environment
20.Summary 1.13 MB 0:00:50 ‎128kbps 110.00 1024x768 ‎15 frames/second 02.The VBA Environment
01.Overview 1.12 MB 0:00:49 ‎128kbps 104.00 1024x768 ‎15 frames/second 03.The VBA Language, Part 1
02.The VBA Project and Components 14.8 MB 0:07:19 ‎128kbps 660.00 1024x768 ‎15 frames/second 03.The VBA Language, Part 1
03.Data Types 26.0 MB 0:17:27 ‎128kbps 363.00 1024x768 ‎15 frames/second 03.The VBA Language, Part 1
04.Objects 2.41 MB 0:01:41 ‎128kbps 95.00 1024x768 ‎15 frames/second 03.The VBA Language, Part 1
05.Operators 8.05 MB 0:05:37 ‎128kbps 229.00 1024x768 ‎15 frames/second 03.The VBA Language, Part 1
06.Essential Functions 16.0 MB 0:09:10 ‎128kbps 580.00 1024x768 ‎15 frames/second 03.The VBA Language, Part 1
07.Summary 715 KB 0:00:32 ‎128kbps 34.00 1024x768 ‎15 frames/second 03.The VBA Language, Part 1
01.Overview 0.98 MB 0:00:42 ‎128kbps 105.00 1024x768 ‎15 frames/second 04.The VBA Language, Part 2
02.Language Constructs 41.3 MB 0:23:05 ‎128kbps 891.00 1024x768 ‎15 frames/second 04.The VBA Language, Part 2
03.Control Flow 27.0 MB 0:14:35 ‎128kbps 843.00 1024x768 ‎15 frames/second 04.The VBA Language, Part 2
04.Extending VBA 20.2 MB 0:08:52 ‎128kbps 1028.00 1024x768 ‎15 frames/second 04.The VBA Language, Part 2
05.Summary 407 KB 0:00:19 ‎128kbps 18.00 1024x768 ‎15 frames/second 04.The VBA Language, Part 2
01.Overview 1.66 MB 0:01:19 ‎128kbps 61.00 1024x768 ‎15 frames/second 05.The Object Model
02.Application Object 5.72 MB 0:02:54 ‎128kbps 860.00 1024x768 ‎15 frames/second 05.The Object Model
03.Active Objects 3.97 MB 0:02:23 ‎128kbps 201.00 1024x768 ‎15 frames/second 05.The Object Model
04.Custom Objects 5.26 MB 0:02:03 ‎128kbps 634.00 1024x768 ‎15 frames/second 05.The Object Model
05.Collections 2.98 MB 0:01:54 ‎128kbps 152.00 1024x768 ‎15 frames/second 05.The Object Model
06.Custom Collections 5.41 MB 0:02:15 ‎128kbps 673.00 1024x768 ‎15 frames/second 05.The Object Model
07.Dialogs 3.38 MB 0:01:39 ‎128kbps 350.00 1024x768 ‎15 frames/second 05.The Object Model
08.Summary 803 KB 0:00:33 ‎128kbps 33.00 1024x768 ‎15 frames/second 05.The Object Model
01.Overview 838 KB 0:00:34 ‎128kbps 104.00 1024x768 ‎15 frames/second 06.The Event Model
02.Windows Messages 8.01 MB 0:04:50 ‎128kbps 419.00 1024x768 ‎15 frames/second 06.The Event Model
03.VBA Events 6.25 MB 0:02:30 ‎128kbps 664.00 1024x768 ‎15 frames/second 06.The Event Model
04.Declaring Variables With Events 3.64 MB 0:01:46 ‎128kbps 808.00 1024x768 ‎15 frames/second 06.The Event Model
05.UserForm Events 5.41 MB 0:02:11 ‎128kbps 683.00 1024x768 ‎15 frames/second 06.The Event Model
06.Summary 1.31 MB 0:00:43 ‎107kbps 960.00 1024x768 ‎15 frames/second 06.The Event Model
01.Overview 1.40 MB 0:00:57 ‎128kbps 116.00 1024x768 ‎15 frames/second 07.Debugging and Error Handling
02.DebugPrint 3.73 MB 0:01:56 ‎128kbps 531.00 1024x768 ‎15 frames/second 07.Debugging and Error Handling
03.DebugAssert 11.1 MB 0:02:29 ‎109kbps 5807.00 1024x768 ‎15 frames/second 07.Debugging and Error Handling
04.Trap 1.55 MB 0:00:44 ‎128kbps 565.00 1024x768 ‎15 frames/second 07.Debugging and Error Handling
05.Trace 3.62 MB 0:01:42 ‎128kbps 577.00 1024x768 ‎15 frames/second 07.Debugging and Error Handling
06.Writing an Error Handler 4.37 MB 0:01:58 ‎128kbps 666.00 1024x768 ‎15 frames/second 07.Debugging and Error Handling
07.VBA Error Trapping Settings 1.67 MB 0:00:57 ‎128kbps 369.00 1024x768 ‎15 frames/second 07.Debugging and Error Handling
08.Errors and the Call Stack 1.78 MB 0:01:11 ‎128kbps 84.00 1024x768 ‎15 frames/second 07.Debugging and Error Handling
09.Demo 5.97 MB 0:01:39 ‎128kbps 768.00 1024x768 ‎15 frames/second 07.Debugging and Error Handling
10.Summary 601 KB 0:00:24 ‎128kbps 46.00 1024x768 ‎15 frames/second 07.Debugging and Error Handling
01.Overview 1.49 MB 0:01:00 ‎128kbps 98.00 1024x768 ‎15 frames/second 08.Putting it Together
02.The Quick Access Toolbar 4.95 MB 0:01:53 ‎128kbps 368.00 1024x768 ‎15 frames/second 08.Putting it Together
03.The Office Fluent User Interface 8.08 MB 0:04:33 ‎128kbps 714.00 1024x768 ‎15 frames/second 08.Putting it Together
04.Demo 1 - Step by Step 6.69 MB 0:02:02 ‎128kbps 914.00 1024x768 ‎15 frames/second 08.Putting it Together
05.Demo 2 - Boxes 2.56 MB 0:01:07 ‎128kbps 492.00 1024x768 ‎15 frames/second 08.Putting it Together
06.Demo 3 - Dynamic Ribbons 4.70 MB 0:02:14 ‎128kbps 729.00 1024x768 ‎15 frames/second 08.Putting it Together
07.Which Customization 2.15 MB 0:01:15 ‎128kbps 291.00 1024x768 ‎15 frames/second 08.Putting it Together
08.RibbonX in Microsoft Access 6.60 MB 0:02:29 ‎128kbps 725.00 1024x768 ‎15 frames/second 08.Putting it Together
09.Project Types 10.0 MB 0:04:31 ‎128kbps 720.00 1024x768 ‎15 frames/second 08.Putting it Together
10.Automatically Starting an Application 2.35 MB 0:01:27 ‎128kbps 353.00 1024x768 ‎15 frames/second 08.Putting it Together
11.Adding Polish 11.9 MB 0:05:16 ‎105kbps 5226.00 1024x768 ‎15 frames/second 08.Putting it Together
12.Summary 642 KB 0:00:26 ‎128kbps 57.00 1024x768 ‎15 frames/second 08.Putting it Together
13.Course Summary 2.23 MB 0:00:36 ‎128kbps 776.00 1024x768 ‎15 frames/second 08.Putting it Together
[/spoiler]
Файлы примеров: присутствуют
Формат видео: WMV
Видео: wmv3, 1024x768, 15fps, 18~5807kbps
Аудио: wma2, 128kbps, Stereo, 44.1kHz
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: Exercise includes slides and code files