automating X

Tutorial: Creating an Excel Database of Your Libronix Resources

Home Macros Scripts Weblinks Other Tools FAQ Links About		In the coming weeks we are going to look at how to go about creating an Excel Database of your Libronix resources. Once you have extracted the data into an Excel file you will be able to sort and filter the data on various fields using Excels built in functions. In this tutorial I will be using Excel 2000 but you should be able follow this tutorial with out any problems in Excel 97 or XP. If this is your first time using the VBA editor I recommend you first have a look at VBA Basics in 15 minutes. It refers to the Word/VBA editor but you will be presented with essentially the same editor for Excel/VBA. For first time/new VBA users I am not going to being throwing about lots of technical terms to confuse you. You can easily find another web site with such terms if you want to be confused. My advice is simply stick with it and have fun. Part 1. Using VBA to Control Another Application Part 2 - Extracting a List of Your Resources into Excel Too come at a yet to be determined date Part 3 - Extracting Metadata from a Resource Part 4 - Manipulating Your Database Using Excel's Sort and Filter Functions Part 5 - Creating a Summary about the Resources in Your Library

	Return
This site is maintained and updated by Andrew. Page Created: 9/8/2003. Page Updated: 13/8/2003 Current Date: