Advanced VB scripting | andersjensenorg

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Power Automate Desktop - Beginner to Pro

Introduction

Welcome (0:31)

Getting Ready

Install Power Automate Desktop and browser extensions (2:36)
Power Automate Desktop Overview (1:13)
Download the lesson files (1:05)
Install Contoso Invoicing Demo App (3:26)

Record Your Actions

Intro to the Recorder (4:06)
Clean up and configuration (2:36)
The Recorder part 2 (3:47)
Refine the flow (3:59)

Variables

Intro to variables and prepare data (1:43)
Text variables (8:48)
Working with lists (8:18)
Numericals (3:54)
Booleans - True/False (2:02)
Leverage DateTimes (5:49)
DataTables (3:58)
DataRows (7:32)

If and Loop

The If and Else if actions (9:22)
Loop condition (7:11)
Advanced loop conditions, part 1 (9:17)
Advanced loop conditions, part 2 (8:13)

Excel

Excel preperations (1:52)
Basic Excel (Create a master Datatable) (14:01)
Prepare the master sheet (Save to Excel) (7:23)
Add sheets for each shop dynamically (2:57)
Write data to Excel (5:26)
Automate Excel formulas, part 1 (3:50)
Automate Excel formulas, part 2 (4:36)
Resize column widths (1:22)
Advanced VB scripting (6:01)

File Handling

Prepare the project, part 1 (2:52)
Prepare the project, part 2 (subflows) (2:32)
Unzip files (4:50)
Handle error files (8:32)
Process the success files (3:45)
Create a log and variable gymnastics (8:42)
Dynamic file naming (3:01)

Browsers

Basic web automation (8:53)
Combine web automation with Excel (6:09)
Iterate Excel (5:03)
Create a log (4:59)
Advanced error-handling (8:47)

Applications

Basic UI automation (6:32)
Selector work (7:36)
Finish building the basic flow (6:41)
Extract invoice data (4:09)
Implement loop (4:43)
Dynamic selectors (advanced) (7:28)

Web extraction

Prepare the data (1:19)
Navigate and speed things up (11:47)
Create a dynamic selector (6:12)
Web extraction (4:10)
Extract multiple pages (next button) (10:14)
Parameterized web scraping (9:13)
Save extractions to Excel (10:06)

Outlook

Prepare the Outlook emails (5:45)
Retrieve emails (6:40)
Process and respond to emails (4:40)
Process based on attachment(s) (10:05)
Log emails to Excel (9:00)

Artificial Intelligence

Intro to AI Recorder (Copilot) (6:32)
Regular recorder (4:05)
UI automation with the Copilot AI Recorder (6:02)
Save Excel (4:55)
The Copilot sidebar (1:57)
Create text with GPT (7:02)

Now what?

AI and Automation Black Belt

Advanced VB scripting

Complete and Continue

Discussion

3 comments