How to Connect VB to Excel

Series Summary

Knowing how to use Microsoft's Excel spreadsheet software is an essential skill for today's office workplace. Most jobs require at the very minimum the ability to navigate through the various sheets of a spreadsheet. The Excel application has been the most widely used spreadsheet program since the early 1990s. In this free video series on computer software, an experienced Excel user demonstrates several features of Microsoft Excel. Find out how to generate percentages, format cells and use macros as shortcuts. Learn to use Excel for a variety of functions, like organizing projects, running a business and keeping accounts records. Use Microsoft Excel to organize schedules, lists and values with the help of this computer software guide.

Video Transcript

"Microsoft Excel is a registered trademark of Microsoft Office products, and I am in no way, shape, or form affiliated with Microsoft Office or Microsoft. What I want to do now is connect Visual Basic to another Excel workbook, and the way to do that is to open up Visual Basic by going to your Tools menu, and you go in your Macros, and you click on the Visual Basic editor. And click, when you click on view when you've got Visual Basic open, you click on Code so that it'll pull up this Code window, and you can go ahead and type in the code. And once you type in the code you go ahead and click Run, and if you look down here now instead of having one book open we have two books open. And that's how you would connect Visual Basic to Excel."