Advanced Excel
Loading...
89
subscribers
104,246
video views
Uploaded videos
1-10 of 10-
Excel -Custom Password Form
rstcomputer
16,997 views
Prompt user for a username and password when a workbook is open. Lots of uses for this.
Shows how to create the form and determine if user entered correct info.
-
Excel - Auto Fill Powerpoint
rstcomputer
2,880 views
Shows how to automatically fill in a powerpoint presentation from Excel, using data from your Excel workbook.
-
Excel - Custom Menu bar that opens a form
rstcomputer
3,723 views
Shows, very quickly, how to create a custom Excel menu bar and menu and have it pop up a custom form.
-
Excel - Creating Custom Functions For Worksheets
rstcomputer
2,785 views
Demo Shows how to create your own custom functions to use in regular worksheets.
-
Excel - Auto MS Access Upload
rstcomputer
28,499 views
Demo shows how to connect to Access programmatically and insert data directly to Access using ADO and SQL from Excel.
Uses two textboxes and a command button.
-
ASP.NET - How to create an Abstract Class
rstcomputer
7,316 views
Demo on how to create a .NET abstract class, inherit it in another class, and use it in a web page.
Sort of a starting point for design patterns.
-
VBA Excel - Type Definition
rstcomputer
5,217 views
Demo in visual basic using a "Type" definition, which is sort of like a mini class. Very useful if you add a lot of variables to a function or sub routine.
-
Excel VBA - Collections
rstcomputer
7,568 views
Demonstrates a how to create the collection object, add data to it, and add the data to a listbox by looping through.
-
VBA - Pull data to Word from Excel
rstcomputer
20,738 views
Video shows how to programmatically pull data from an Excel workbook and automatically populate Word.
-
VBA Excel - Pulling from Access
rstcomputer
8,512 views
Shows how to pull data from programmatically from Microsoft Access and put to Excel. Access is never opened - the code connects to access and uses SQL to pull the data.
Advertisement
About Advanced Excel
more
less
Play all(10)