Канал: Gove Allen

GMT20240410 183544 Recording 1920x1080

GMT20240410 183544 Recording 1920x1080

Sending gmail with VBA

Sending gmail with VBA

Controlling chrome with VBA

Controlling chrome with VBA

Using vba to send requests to Generative AI (Gemini)

Using vba to send requests to Generative AI (Gemini)

Parsing text files with VBA

Parsing text files with VBA

Insert records into MS Sql Server and MS Access with VBA in Excel

Insert records into MS Sql Server and MS Access with VBA in Excel

VBA reading data from a database

VBA reading data from a database

Automating Pivot Tables with VBA

Automating Pivot Tables with VBA

VBA: Usinge the Office File Dialog

VBA: Usinge the Office File Dialog

Creating forms with VBA in Excel

Creating forms with VBA in Excel

Building user forms in VBA

Building user forms in VBA

VBA Introduction to User Forms

VBA Introduction to User Forms

VBA: Arrays and the Next Nearest City algorithm

VBA: Arrays and the Next Nearest City algorithm

Introduction to Arrays in VBA

Introduction to Arrays in VBA

Devugging and Error Handling in VBA

Devugging and Error Handling in VBA

VBA: A function to validate a 10 digit ISBN

VBA: A function to validate a 10 digit ISBN

String Manipulation Functions in VBA

String Manipulation Functions in VBA

VBA If, Select, User Defined Functions

VBA If, Select, User Defined Functions

Working with ranges in VBA

Working with ranges in VBA

VBA Writing Sub Procedures from Scratch

VBA Writing Sub Procedures from Scratch

VBA loops

VBA loops

Working with Worksheets, workbooks and shapes in VBA

Working with Worksheets, workbooks and shapes in VBA

Copy Oracle Walet to VM

Copy Oracle Walet to VM

Terminate an Oracle Autonomous Database

Terminate an Oracle Autonomous Database

Create an Oracle Autonomous Database

Create an Oracle Autonomous Database

Submit the IP address of your oracle comput instance to your professor

Submit the IP address of your oracle comput instance to your professor

Recording and Editing VBA Macros

Recording and Editing VBA Macros

Grant another person access to your VM using an RSA public pkey

Grant another person access to your VM using an RSA public pkey

connect to oracle cloud vm from mac os

connect to oracle cloud vm from mac os

Connect to Oracle Cloud VM

Connect to Oracle Cloud VM

Create a Compute Instance on the Oracle Cloud Free Tier

Create a Compute Instance on the Oracle Cloud Free Tier

Variables and Constants in VBA

Variables and Constants in VBA

Setting up your student oracle cloud account

Setting up your student oracle cloud account

Introduction to VBA Objects

Introduction to VBA Objects

Accessing Oracle Autonomous DB throug Cloud Console

Accessing Oracle Autonomous DB throug Cloud Console

Submit direct login link for Oracle Autonomous Database

Submit direct login link for Oracle Autonomous Database

Creating user accounts on the Oracle Autonomous Database

Creating user accounts on the Oracle Autonomous Database

Logging in to Oracle through Cloud Console

Logging in to Oracle through Cloud Console

Logging in to your Oracle Cloud Account

Logging in to your Oracle Cloud Account

create oracle autonomous database

create oracle autonomous database

Automating solver with VBA

Automating solver with VBA

Building custom ribbons for macro-enabled workboks

Building custom ribbons for macro-enabled workboks

Sening gmal and text messages from vba

Sening gmal and text messages from vba

Controlling Chrome from VBA

Controlling Chrome from VBA

Interacting with Google Sheets using VBA

Interacting with Google Sheets using VBA

parsing text files in VBA

parsing text files in VBA

Modicing an access database from excel wth VBA

Modicing an access database from excel wth VBA

Reading data from SQL Server with VBA

Reading data from SQL Server with VBA

Manipulating pivot tables with VBA

Manipulating pivot tables with VBA

Using Excel built in dialog boxes in VBA

Using Excel built in dialog boxes in VBA

Building charts wtih VBA

Building charts wtih VBA

Mulit select listbox in VBA

Mulit select listbox in VBA

is201 review vba fall 2023

is201 review vba fall 2023

VBA Introduction to userforms

VBA Introduction to userforms

VBA traveling Salesman

VBA traveling Salesman

Creating and using arrays in VBA

Creating and using arrays in VBA

VBA Error trapping and debugging

VBA Error trapping and debugging

Building User Defined Functions in VBA

Building User Defined Functions in VBA

Making decision in VBA

Making decision in VBA

ranges and cells in VBA

ranges and cells in VBA

Loops in VBA

Loops in VBA

Built in objects and Collections VBA

Built in objects and Collections VBA

Record and edit a macro

Record and edit a macro

Variables in VBA

Variables in VBA

Introduction to macros and objects

Introduction to macros and objects

Automating Excel with Office Script

Automating Excel with Office Script

Creating ribbon customizations in Excel

Creating ribbon customizations in Excel

Using VBA to send gmail

Using VBA to send gmail

Controlling Chrome with Selenium and VBA

Controlling Chrome with Selenium and VBA

VBA to push data to google sheets

VBA to push data to google sheets

Parsing Text Files with Excel VBA

Parsing Text Files with Excel VBA

Inserting data into SQL Server with VBA

Inserting data into SQL Server with VBA

Using VBA to read data from SQL Server

Using VBA to read data from SQL Server

Automating pivot tables with VBA

Automating pivot tables with VBA

Working with files and the File Dialog in VBA

Working with files and the File Dialog in VBA

Manipulating charts with VBA

Manipulating charts with VBA

Working with multi select listboxes in VBA

Working with multi select listboxes in VBA

Introduction to Userforms in VBA

Introduction to Userforms in VBA

Next Nearest City in VBA

Next Nearest City in VBA

Error Handling and Debugging in VBA

Error Handling and Debugging in VBA

Buildig a custom function in VBA

Buildig a custom function in VBA

Strung Functions in VBA

Strung Functions in VBA

Conditional branching in VBA

Conditional branching in VBA

Working with cells and ranges in VBA

Working with cells and ranges in VBA

Visual Schedule in VBA and Excel

Visual Schedule in VBA and Excel

Using built in collections in VBA

Using built in collections in VBA

Recording and Editing Macros in VBA

Recording and Editing Macros in VBA

Creating Users in an Oracle Autonomous Database

Creating Users in an Oracle Autonomous Database

VBA Variables and datatypes

VBA Variables and datatypes

Setting up a free databse in the Oracle cloud

Setting up a free databse in the Oracle cloud

Automating Solver with VBA

Automating Solver with VBA

Modifying the Ribbon and Building Excel add ins

Modifying the Ribbon and Building Excel add ins

sending gmail and text messages wiht VBA

sending gmail and text messages wiht VBA

controlling Chrome with VBA

controlling Chrome with VBA

Using Google Sheet as a data repository for Excel and VBA

Using Google Sheet as a data repository for Excel and VBA

VBA writing to SQL Server and MS Access

VBA writing to SQL Server and MS Access

Accessing SQL Server from VBA

Accessing SQL Server from VBA

Making Pivot Tables with VBA

Making Pivot Tables with VBA

Making Charts with VBA

Making Charts with VBA

VBA Multiselect listbox

VBA Multiselect listbox

Introduction to VBA Forms

Introduction to VBA Forms

More Arrays in VBA

More Arrays in VBA

Introduction to Arrays in VBA

Introduction to Arrays in VBA

Building an Error Trap in VBA

Building an Error Trap in VBA

VBA function to validate ten digit ISBNs

VBA function to validate ten digit ISBNs

VBA built in String Functions

VBA built in String Functions

Conditional Branching

Conditional Branching

Working with Ranges

Working with Ranges

Writing Macros from Scratch

Writing Macros from Scratch

Loops in VBA

Loops in VBA

Built in Objects and Collections

Built in Objects and Collections

Recording and editing macros

Recording and editing macros

VBA Variables and Constants

VBA Variables and Constants

vba Course Introduction-day 1.

vba Course Introduction-day 1.

Jul 4, 2022 Colonial School

Jul 4, 2022 Colonial School

Automating Excel with JavaScript and the Jade add in

Automating Excel with JavaScript and the Jade add in

Creating Custom Workbook Ribbons

Creating Custom Workbook Ribbons

Automating Excel Solver with VBA

Automating Excel Solver with VBA

Sending gmail with VBA

Sending gmail with VBA

Working with google sheets

Working with google sheets

Controlling Chrome with VBA

Controlling Chrome with VBA

Parsing text files with VBA

Parsing text files with VBA

Modifying databases with VBA

Modifying databases with VBA

Reading from a database with VBA

Reading from a database with VBA

Making Excel Pivot Tables with VBA

Making Excel Pivot Tables with VBA

Processing Files in a Folder with VBA

Processing Files in a Folder with VBA

Building Charts with VBA

Building Charts with VBA

Option buttons and list boxes in VBA user forms

Option buttons and list boxes in VBA user forms

VBA Introduction to user forms

VBA Introduction to user forms

VBA Arrays and the Travelling Salesman

VBA Arrays and the Travelling Salesman

Introduction to Arrays in VBA

Introduction to Arrays in VBA

Debugging and Error handling in VBA

Debugging and Error handling in VBA

Building Functions in VBA

Building Functions in VBA

VBA String Functions

VBA String Functions

Conditional Branching in VBA

Conditional Branching in VBA

Working with Ranges

Working with Ranges

using VBA to visualize a schedule in Excel

using VBA to visualize a schedule in Excel

Three loops in VBA

Three loops in VBA

VBA built in collections and objects

VBA built in collections and objects

Recording a macro to get stock information

Recording a macro to get stock information

setting up a free google vps

setting up a free google vps

Variables in VBA

Variables in VBA

Introduction to Objects in VBA (and class administration)

Introduction to Objects in VBA (and class administration)

Using the JavaScript Automation Development (JADE) add-in for Microsoft Excel

Using the JavaScript Automation Development (JADE) add-in for Microsoft Excel

Automating Solver with VBA

Automating Solver with VBA

Creating Custom Ribbons for VBA

Creating Custom Ribbons for VBA

Sending gmail with VBA

Sending gmail with VBA

Automating Chrome with VBA

Automating Chrome with VBA

Parsing Text Files with VBA

Parsing Text Files with VBA

Writing to a database with VBA

Writing to a database with VBA

Reading data from a relational database with VBA

Reading data from a relational database with VBA

pivot tables with vba

pivot tables with vba

Filesystem dialog and accessing files using DIR in VBA

Filesystem dialog and accessing files using DIR in VBA

Working with chart objects in VBA

Working with chart objects in VBA

Normalization

Normalization

intermediate userforms with VBA

intermediate userforms with VBA

introduction to user forms with VBA

introduction to user forms with VBA

Finishing the travelling salesman problem using Arrays in VBA.

Finishing the travelling salesman problem using Arrays in VBA.

Initializing Arrays

Initializing Arrays

debugging and error trapping

debugging and error trapping

ISBN Validator

ISBN Validator

Manipulating strings with VBA

Manipulating strings with VBA

conditional branching in VBA: Using IF..Then and Select...Case

conditional branching in VBA: Using IF..Then and Select...Case

working with ranges

working with ranges

Building Macros from Scratch

Building Macros from Scratch

VBA Loops

VBA Loops

VBA: Workbooks, Worksheets, and shapes collections

VBA: Workbooks, Worksheets, and shapes collections

Record a macro to use Legacy Web Query and edit it to make it work

Record a macro to use Legacy Web Query and edit it to make it work

Variables and Datatypes in VBA

Variables and Datatypes in VBA

Introduction to the course and what are objects, properties and methids in VBA

Introduction to the course and what are objects, properties and methids in VBA

Party cut watermelon

Party cut watermelon

Striking an 18th century token replica

Striking an 18th century token replica

Verify Azure Account for Education

Verify Azure Account for Education

Week 7 Update

Week 7 Update

Controlling IE with VBA

Controlling IE with VBA

Setting up VPS for Cassandra

Setting up VPS for Cassandra

Configuring Access to your VPS

Configuring Access to your VPS

Making Pivottables with vba

Making Pivottables with vba

working with files in Excel VBA

working with files in Excel VBA

Excel VBA Charts

Excel VBA Charts

VBA userforms, day 2

VBA userforms, day 2

Intro to forms

Intro to forms

introduction to arrays

introduction to arrays

debugging and error handling in vba

debugging and error handling in vba

isbn10

isbn10

string functions in VBA

string functions in VBA

conditional branching

conditional branching

Working with ranges

Working with ranges

VBA to show scheduled visually

VBA to show scheduled visually

Three kinds of loops in VBA

Three kinds of loops in VBA

Overview of the Atlas Query Processor

Overview of the Atlas Query Processor

vscode

vscode

Excel VBA Built-In Objects and Collections

Excel VBA Built-In Objects and Collections

Comparing Binary and Ternary Associatinos

Comparing Binary and Ternary Associatinos

Recording an macro to automate Excel Web Query

Recording an macro to automate Excel Web Query

Installing the MyEducator Addin

Installing the MyEducator Addin

Constants and Variables in VBA

Constants and Variables in VBA

Granting Professor Allen access to your VPS

Granting Professor Allen access to your VPS

Disallowing password authentication on your VPS

Disallowing password authentication on your VPS

login to linux VPS without specifying password

login to linux VPS without specifying password