Using Excel As Your Database
Often I have thought, if I could have write “Select EmployeeName From Sheet Where EmployeeID=123” and use this on my excel sheet, my life would be simpler. So today we will learn how to do this.
People spend a lot of time thinking whether to use Excel as their database or not. Eventually they start using Access or SQL Server etc.
Today we will learn how to use Excel as a Database and how we to use SQL statements to get what we want. We will learn how to build a form like above.
Putting It All Together – Our First VBA Application [Part 4 of 5 – Excel VBA Crash Course]
In part 4 of our VBA Crash Course, we are going to create our very first VBA application using what we learned so far.
We will take the “We Are Nuts” example and create a daily sales tracker application using all the things you have learned so far. You can download the example VBA workbook and play with it to learn better.
Automating Repetitive Tasks
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Over at Newton Excel Bach I spotted the Dynamically Defined Dancing Pendulums. Doug had used Strand7 for the animation.
I thought I could do that in Excel and did.
This post demonstrates some of some basic VBA techniques used to simplify repetitive tasks used during the construction of the project.
For a full project description visit Excel Hero.com.