Over at Automated Word Mail Merge I have a sample workbook for creating a mail merge in Excel using VBA, but I've felt the example wasn't the best. So I produced another, and here it is.
Custom Office Programming and Automation
IncSight DB lets you set up professional Excel dashboards linked to an Excel database. Set up your first Excel dashboard report in less than an hour. Add any number of reports. You can update your reports in seconds because they're linked to an Excel database. Choose from 20 Excel templates, plus 20 color schemes. These dashboards use only Excel workbooks. Nothing is hidden or protected, and there's nothing to install.
Follow Me