Construct an Excel Sheet Using VBA Automation

In this Microsoft Access tutorial, I will show you how to use VBA to automate the creation and formatting of an Excel workbook from an Access database. You will learn how to send data from Access to Excel and apply formatting like colors and cell alignment to make your exports more presentable.

Lydia from Santa Clara, California (a Platinum Member) asks: I'd like to be able to export some data from my Access database to send to customers. Since they don't have Access, I'm using an Excel export. I'm using the simple export that you showed in your previous videos, but it's not very pretty. Is there any way to add some formatting to this? Maybe some colors, change the cell alignment, that kind of stuff.

Prerequisites

• Export to Excel
• Intro to VBA
• Recordsets
• Late Binding

Recommended Courses

• Access Developer Courses

Up Next

• Excel Automation, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, VBA Excel automation, exporting data from Access, Excel formatting VBA, automate Excel formatting, Access to Excel export example, Excel cell alignment VBA, add color VBA Excel, creating Excel sheet VBA, set Excel application VBA, late binding VBA, early vs late binding VBA, looping through records VBA