Skip to content

1. Getting Started

Jump to bottom
Craig edited this page Sep 8, 2018 · 4 revisions

What You Need to Know to Use xlFrame

An advanced knowledge of Visual Basic for Applications (VBA) is NOT required to get going with xlFrame; however, you will need to know a few of the basics such as:

  • Using variables
  • Using functions and subroutines
  • Reading from and writing to cells in an Excel workbook using the "Range" object
  • Organization of VBA projects (modules)
  • Instantiating and using existing classes - Creating classes of your own is not necessary
  • Using Microsoft's Intellisense to guide you

These are not difficult concepts to learn, and online examples are abundant. You can probably pick these things up with about 5-10 hours of your time invested. If you are new to VBA, I recommend using the following website to come up to speed: http://www.excel-easy.com/vba.html

Importing the Files

Download and save the files in the "Modules" and "Class Modules" folders. From Microsoft Excel, access the VBA integrated development environment (IDE). You can get there quickly by pressing Alt+F11 within Excel. From the IDE's menu, select "File->Import File..." and browse to the location where you saved the files. You'll have to import each of the modules and class modules one at a time.

Clone this wiki locally