|
|
|
Word Automation VBA Code
VBA syntax to create Word documents ... make beautiful reports from Access! or Excel, PowerPoint, and even Word!
|
|
|
|
VBA syntax to create Word documents ... make beautiful reports from Access! or Excel, PowerPoint, and even Word!
| File name | Description and Link |
|---|---|
| Access_WordAutomation_Chemistry_s4p.zip | Zip file containing Access accdb file with VBA to create Word documents,
Access_WordAutomation_Chemistry_s4p.accdb,
and a folder with image files
https://msaccessgurus.com/tool/download/Access_WordAutomation_Chemistry_s4p.zip |
| WordAutomationVBA_s4p.docx | Word document with lots of VBA you can pattern after
https://msaccessgurus.com/VBA/Documents/WordAutomationVBA_s4p.docx View PDF https://msaccessgurus.com/VBA/Documents/WordAutomationVBA_s4p.pdf |
| Fonts_Windows_s4p.pdf | Word document saved as PDF
that documents Font installed in Windows (these are mine).
Second column of the table shows what all printable ASCII characters look like in each font.
Run on your own system using Word_Make_Font_List_s4p
code in Access_WordAutomation_Chemistry_s4p.accdb
https://msaccessgurus.com/VBA/Documents/Fonts_Windows_s4p.pdf |
| Fonts_Windows_Short_s4p.pdf | Word document saved as PDF
that documents Font installed in Windows (these are mine).
Second column of the table shows what all upper and lower case letters look like in each font.
Run on your own system using Word_Make_Font_List_s4p
code in Access_WordAutomation_Chemistry_s4p.accdb
https://msaccessgurus.com/VBA/Documents/Fonts_Windows_Short_s4p.pdf |
| Word_Styles_s4p.pdf | Word document saved as PDF
that enumerat built-in Paragraph, Character, Tables, and Lists styles.
Run using Word_Make_Styles_List_s4p
code in Access_WordAutomation_Chemistry_s4p.accdb
https://msaccessgurus.com/VBA/Documents/Word_Styles_s4p.pdf |
| Word_Images_Chemistry_s4p.pdf | Word document saved as PDF
with content from a table in Access
and image files from the \images folder.
Run using Word_Make_Images_Chemistry_s4p
code in Access_WordAutomation_Chemistry_s4p.accdb
https://msaccessgurus.com/VBA/Documents/Word_Images_Chemistry_s4p.pdf |
| DataDictionary_Northwind_s4p.pdf | Word document saved as PDF
created by Access that documents table structure, indexes,
and related tables in the Northwind database template.
https://msaccessgurus.com/VBA/Documents/DataDictionary_Northwind_s4p.pdf To document your databases, download the free Analyzer here: https://msaccessgurus.com/tool/Analyzer.htm |
Presentation for Access Lunchtime
Watch on YouTube: Word Automation from Access VBA Deep Dive (52:28)
I've used Word for a long time; way before Access was even conceived! One of the first things I learned was how to use styles ... I was embedding PostScript printer commands into documentation since we didn't have the desktop publishing capabilities we have today and the printer could do so much more than software. There wasn't WYSIWYG (What You See Is What You Get) so there was lots of back and forth between the screen and printed page! Until I learned about Word Styles, WordPerfect had been my favorite word processor.
These days, I use Word a lot, and love all it's great features!
Sometimes, instead of making a report in Access, I count on Word to help me create a high quality document.
here's the link for this page in case you want to copy it:
https://msaccessgurus.com/VBA/WordAutomate.htm
Email me to tell me how wonderful you think this calendar is! I love hearing about what you're doing with Access.
Let's connect and team-develop your application together. I teach you how to do it yourself. As needed, while we build somothing great together, I'll pull in code and features from my vast libraries, cutting out lots of development time.
I like teaching people who want to do it themself,
and need someone to guide them past the obstacles
and teach better ways.
For training and programming, email me at training@msAccessGurus
I look forward to hearing from you ~
~ crystal