Sep 8 2017

Making Microsoft’s Vision a Reality

Last week’s post discussed Microsoft’s vision for its products: Their vision was to design their desktop productivity tools (Microsoft Office) so that the user could fully integrated and automated any and all of those applications, such as Microsoft Excel and Microsoft Access.


But how do professional Microsoft Excel consultants and programmers for example meet this imagined future? What can these Excel users do with the Microsoft Office applications?

This post is not about saving hours or days per week that were previously spent on mundane tedious tasks, such as copying and pasting data by leveraging Excel VBA. This post is about using VBA to integrate two or more Microsoft Office applications.

If you as an Excel consultant, a staff accountant or a financial systems analyst for example take the time and effort to integrate and automate your work, the benefits are large:
• You can put the VBA in one or more files to be integrated and automated. Best to put into one app, such as Excel
• Use VBA to take data from Access, into Excel, then off to PowerPoint, and us Outlook to distribute, via the click of a button
• If you are really good, have your work completed before you walk in the door each day
• The sky is the limit on how good you can become, and soon you will find yourself being the office Guru.

This is an Excel Hint: These are just a few of the advantages attaining Microsoft’s vision would offer. If you would like to learn more, read the full blog post at our Excel Consultant website.

If you are looking to hire an Excel consultant, we are available, you can work with Jacob Hilderbrand (Microsoft Excel MVP), VBA guru, reach out to learn more.

Random Posts

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 


Comments are closed.

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks