Extend your Excel VBA programs

Integrate with MS-Word, MS-PowerPoint, send Outlook emails, access the Internet and interface with other programs!


You will need this set of skills and technologies in almost every Excel VBA project

Exchange data with other sources: import and export data fast.

Automate Office processes: reports, presentations, email notifications.

Understand how the Internet works and work with popular file formats.

I'm excited to invite you to take the second course in my program: Beyond Excel Boundaries with VBA: Office, Files and Internet

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, automatically created and sent with an email message
  • You will be able to automate integration with other applications: two VBA techniques for importing and exporting files are demonstrated
  • You will be able to employ Internet technologies: understand how the Internet works. Parse HTML and Work with XML and JSON files. Consume published API's and do web-scrapping

In this course you will discover...

  How to create Word reports and PowerPoint presentations, dynamically populated with Excel data

With Excel VBA you can write a program that automatically creates impressive Office reports, such as a PowerPoint  presentation populated with data you maintain in Excel.
This is a management presentation you will create in the course from an Excel table data.

  How the Internet works and how to get web data in several ways

With Excel VBA you can send requests and receive responses from the Internet and parse common file formats: HTML, XML, JSON.
This slide is taken from the course section in which I explain how the Internet works. You will work with Internet data in several ways: API, Web Service, Web-scrapping
What you will get when enrolling to this course:
  • 9 hours in 28 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 4-course program delivers to you an un-matched combination of skill-sets, typically never found in a single, coherent and complete program.

  • 3 Quizzes

Each module closes with a quiz. The quizzes are 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!

  • 3 Assignments

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!

  • Assignments complete solutions: Excel VBA code for download

Download my suggestion for possible solutions to the assignments. These are complete, fully working solutions 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!

This course covers essential technologies and extensions to meet the business requirements of business solutions

Working with Files

In this module you'll learn one of the most popular techniques to integrate Excel with other applications: text files. You'll also work with folders and files and embed images within your Worksheets. You will discover:

  • Embedding an image file in a Worksheet
  • Creating slick PDF reports
  • Working with files and folders
  • Importing and exporting text files
  • Importing and exporting text files using the streaming object
  • Assignment: Create a slick PDF report with Excel data and chart

Cross Office Programming

In this module 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

Accessing the Internet

In this module you will understand the principles of the Internet technology, popular protocols and file formats used to store and exchange data. You will consume a published API over the Internet and do web-scrapping on eBay. You will discover:

  • Understanding Internet fundamentals
  • Working with popular file formats: XML, JSON, CSV
  • Consuming a published Internet API
  • Web-scrapping into Excel Worksheet
  • Assignment: Exchange rates chart based on data published on the Internet

Watch A Sample Lesson from the Course

About the First Course

Be sure to master Excel VBA before taking this advanced course. The FIRST course in my program: Computer Programming with Excel VBA will make you an Excel VBA master, ready to take up this advanced course.

Who am I and why I am the best guide for you


My name is Mor Sagmon. 30 years ago, I co-authored a book teaching advanced Macros in Lotus 1-2-3 (it was the popular "Excel" before Excel came to be). Back then I delivered my first project: a financial reporting system for The 4 Seasons Hotel.

After graduating Computer Science, Information Systems and Databases at the Technion Institute of Technology, I continued delivering software projects implemented in a wide array of technologies.

Having served as the CIO of Avgol, a manufacturing company, I experienced leading complex IT projects from the other side: now as a customer.

The best school for me was probably my 15 years with the business software giant, SAP. After leading large software projects with customers such as Bose, Chevron, Shell Trading and others, I moved on to less technical positions, including business development, cutting-edge research,  academia relations manager, and sales operations.

Today I combine my unique experience and expertise in technology and business, and deliver beautiful, intuitive to use business software solutions, mainly built with Excel VBA and the MySQL Database. This extensive breadth of knowledge and experience with real business customers, enables me to offer you the top guidance possible in becoming a successful business software consultant, and an expert Excel VBA programmer.

Some of my customers have this to say about me:

Darren Dickey, VP Sales, Hospitality Designs

Mor is incredibly insightful. He thinks critically about the project and provides feedback and suggestions that improves on the scope. He was very responsive during the project and took great pride in the work he completed. I have no reservations in recommending him. I will be hiring him again for similar projects.

Rick Harris, Founder, Innovator-In-Chief, Customer Faithful Ltd

Great working with Mor. He took time and effort to discuss exactly what I needed, including suggestions which helped me a lot. Very professional – I expect to use Mor again and would not hesitate to recommend him to others.

Pedro Baez, President, PPAB Consultants

Mor has delivered a great product and ahead of schedule. During the process of creating the tool requested, Mor was patient and persistent on learning my needs, purpose and goal for the tool, before he started the creative process. His attention to detail was keen and productive. I will continue to use his services as other projects become necessary.

Extend your Excel VBA programs

There is no other course that covers so many required advanced technologies. Enrich your skill-set today!

Feel free to contact me

I'm waiting to hear from you. email me directly at [email protected]. You can also find me on LinkedIn and my Facebook Page.

Andrew Dove, Scotland


"I have to say that I am very impressed with your course.

The major positives that I have observed so far are:

  • Clarity of explanation

  • Obvious authority on the subject matter

  • Getting into the more advanced areas

  • Value for money


Personally, I am planning to make VBA development and Excel training a full time occupation by the end of this year.  As such I may well be interested in your supervision offering further down the line".


50% Complete

Two Step

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.