How to Construct an Excel Sheet using VBA Automation from Microsoft Access, Part 3

In this Microsoft Access tutorial, I will show you how to automate exporting data from Access to an Excel sheet with VBA. We will cover saving the file, suppressing warning messages, applying formatting to the Excel sheet, and more. This is part 3.
BECOME A MEMBER:
UA-cam: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
Excel Automation 3: 599cd.com/ExcelAutomation3
PREREQUISITES:
Excel Automation, Part 2: 599cd.com/ExcelAutomation2
RECOMMENDED COURSES:
Access Developer Courses: 599cd.com/Developer
Word Automation: 599cd.com/ACD39
Document Index: 599cd.com/DocumentIndex
Send Email Outlook: 599cd.com/EmailSeminar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database,, VBA Excel automation, Access VBA export Excel, Excel sheet formatting VBA, VBA create new Excel file, Excel VBA save workbook, Excel VBA set font color, Excel VBA set background color, Excel VBA align column, VBA automate Excel, Export Access data to Excel, Late binding in VBA, Excel VBA horizontal alignment
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@Jojosmith342]

all thumbs up to the best teacher Richard Rost. Thank you Richard for another valuable tutorial

[@JRVerster]

I would love to see more Excel automations with Access

[@dmfriscia]

More EXCEL Automation, please.

[@shawnbumgarner5638]

Great stuff! Very useful for sure! I would love to see more VBA automation related for sure. Please keep them coming, you do a great job of explaining the steps involved.

[@robertconrad7269]

More please, I usually use macros in Excel for formatting after exporting from Access. I would rather do it all in Access. Thanks for all you do.

[@Nigel1writer]

Yes please! Very interesting. Thanks Richard

[@alializadeh8195]

Please continue to inform us ... !!

[@dorkf1sh]

This is the knowledge I need. My team uses Access with Excel extensively and anything I can do to automate processes is worth gold

[@khalil547]

Thx Richard ! Awesome 👌 we need to dive more!

[@kentdutrieux8886]

I want more!!!!!!

[@RickTapkey2]

More please!!

[@alandrewgibson]

Nice work thank you!

[@RoadsterLoverMedia]

more please. bolding, page bursting with page numbers, Fit to and how tp get the formatting verbs list you are using.

[@ahealy5898]

This has been really helpful. I would love to know if there is some way of exporting a persons picutre in each record into Excel

[@wlbraun2024]

Impressive!

[@xavierbatlle1828]

An idea for a new Tech Help. How to save data in the "my documents" folder. 😊

[@sweetvideos4182]

More please

[@alializadeh8195]

Thanks

[@goldenmask6689]

Thanks...

[@gregoryjeffries8475]

Want to learn more about excel automation, please.

[@larrybellamy6114]

I enjoyed watching the three lessons and I want to know if there is possible to add multiple sheets on Excel workbook that can be pulled from the queries. The automations for reporting are becoming more demands when the leaderships ask for. I do thank you for the friendly reminders the courses that relate to the automations. Rise the Fist!

[@cruzinsweetsntreats]

Seems logical (Spock). As you can bring in an Access database to Excel. 🤔

[@divyanshusaini6154]

Please make a video for automatically pull data from excel to access after a regular interval. Say, I install some devices that can sync to excel. But I dont now how to sync it to access. So i am thinking about syncing the devices to excel and then sync Access with that excel file.

[@rodgerdjr]

I would like more. Can you show us using specific ranges, so the color is not all the way to the end for the row header. Can we use .With Selection./End With. What if we create a module and use ENUMS for the -4131 and set it to our own "LAlign" variable. Then we add that to our template like you have. Good call out that using Late Binding we do not get those built in "names" . I was stating do create an Excel sheet that will create more of a report look so it looks for certain fields as my header and then fills in the detail. So, it would group my data like a report would and not repeat the same fields over and over. I will need to nest my loops. This gives me a better starting point. Thank you!!
Great way to learn this in small chunks. I like how you create it show us and then go back and build upon it.
I would like to see a Part 4/5/6 :)

[@RungeCarl]

I want to know more please

[@timbo4127]

Me too

[@iljak2914]

I think this method is to slow, for one line you need about 0,4 second... If you have 100.000 lines... Maybe you have alternative and faster method , maybe with array... Thanks and regards