Business Automation with VBA – Office Integration
Learn how to extend your Microsoft Excel VBA programs to integrate with MS-Word, MS-PowerPoint and send Outlook emails
You will manipulate other Office programs to automatically generate Word and PowerPoint reports, populated with Excel data, and even send them as email attachments using Outlook.
In this course you will discover:
✔ Sending an Email message with MS-Outlook
✔ Generating MS-Word documents with Excel data
✔ Generating MS-PowerPoint presentations with Excel data
✔ Assignment: PowerPoint report generator to managers on their hiring candidates status, sent to them by email
I'm excited to invite you to take the second course in my program: Beyond Excel Boundaries with VBA: Office Integration
You will need this set of skills and technologies in many Excel VBA projects.
Integrate with MS-Word, MS-PowerPoint, send Outlook emails.
Look what can happen to you after having completed this course:
- You will be Competitive: do more than just automating Excel. Offer integration projects with other technologies and systems
- You will be able to create impressive management reports: automate Word and PowerPoint reports based on your custom templates
- You will be able to automate notification: Automate HTML-designed Email notifications from your application with attachments
This course covers essential technologies and extensions to meet the business requirements of business solutions.
You will manipulate other Office programs to automatically generate Word and PowerPoint reports, populated with Excel data, and even send them as email attachments using Outlook. You will discover:
- Sending an Email message with MS-Outlook
- Generating MS-Word documents with Excel data
- Generating MS-PowerPoint presentations with Excel data
- Assignment: PowerPoint report generator to managers on their hiring candidates status, sent to them by email
What you will get when enrolling to this course:
- 2.5 hours in 9 recorded, hands-on sessions
Each session was carefully planned, its code was written and verified and the video was edited to reflect a balanced blend of slides lecture with hands-on demo.
The course is structured to build a gradual learning curve. With each session you conquer another goal, expand your skills and experience.
The harmonized planning and orchestration of the complete 8-course program delivers to you an unmatched combination of skill-sets, typically never found in a single, coherent and complete program.
- 1 Quiz
The course closes with a quiz. The quiz is designed to measure your deep understanding of the material. Repeating a sentence you heard in the course is not enough to pass the quiz.
Only true understanding gained through practice leads to successful professionals - and that is what I aim for you!
- 1 Assignment
Writing code that works for real business needs will earn you the practice and skill you need. The assignments are engineered to confront you with real business challenges and are considered an important part of your training.
I always say: an assignment is your opportunity to express yourself!
- Assignment's complete solution: Excel VBA code for download
Download my suggestion for a possible solution to the assignment. This is a complete, fully working solution that will expand and enrich your knowledge and techniques for implementing business challenges.
I explain my solution for each and every assignment in a dedicated, detailed session, so these are important lessons in and of themselves - don't skip those sessions!