NB: This post is based on excerpts from an update I sent to to my Excel Heaven Visual Basic Automation club members today.
Last week, I mentioned that I would be sending you a:
“…gift you can use in your work i.e. an Excel VB app called the “Switch Board” that you can copy to your PC and with a few entries in the settings table, use to open other files on your PC without needing to search all over for them. The visual basic code will be open so you can view and study it, towards learning how to build one.”
The attached is an annotated diagram, with explanatory notes/comments that I created (based on an original version I found on Pierre LeClerc’s website at the time) in 2008
I used it as a marketing tool to illustrate”how a LOW COST, easy to use/maintain and highly user-friendly Data Management/Report Generation System can be setup for a corporate organization using MS Excel-VB automation.
Note the reference in the diagram to “The Switchboard” as a “Single Screen Workbook With Labeled, Hyper linked Command Buttons”.
It (i.e. “The Switchboard”) enables ANY user click on labeled command buttons to quickly open ANY workbook they wish to use, without having to manually search through folders on the PC or company intranet.
This kind of Data Management/Report Generation System can be easily setup in ANY organization, by a user who has acquired the needed competence.
As members of my Excel-VB club (see our closed/private/paid-members only page here), you will be getting:
1. a zipped folder containing a switchboard linked to other documents shown in this diagram, so you can test drive it and get a feel for how easy it can make your life as a results focused business user.
2. Then I will follow it up with a video showing how to setup the whole system.
3. Most importantly, you will be able to request my support in applying what you learn to boost productivity in YOUR own workplace.
In your service,
Tayo
Posted on 16 March 2016
Tags: Download A Useful Infographic, How can a "Switchboard" Make Your Life Easier, in an MS Excel-VB driven Corporate Data Management/Report Generation System
About the Author
Tayo K. Solagbade is a Location Independent Performance Improvement Specialist and Multipreneur (i.e. a highly versatile/multi-skilled entrepreneur), with a bias for delivering Best Practice solutions to Farm Businesses and others.
Since 2002, he has earned multiple streams of income providing individuals and organisations with personal development training and coaching, custom MS Excel-VB solutions, web marketing systems, freelance writing services, and best practice extension support services (for farm business owners).
Tayo is the author of the Self-Development (SD) Bible™, the popular Livestock Feed Formulation Handbook, and developer of its accompanying Excel-VB driven Ration Formulator - as well as the increasingly popular Monthly Poultry Farm Manager app.
On 1st April 2013, Tayo (who reads, writes and speaks the French language) relocated to Cotonou, in the French Speaking Benin Republic on the first lap of his slow travels across the West African region. His key purpose is to deliver talks, seminars and workshops on his key areas of focus and interest to interested audiences (Email tayo at tksola dot com for details).
When he's not amazing clients with his superhuman skills (wink), Tayo works as the creative force behind his Daily Self-Development Nuggets blog - on which he also publishes previews of paid issues of The Farm CEO™ Newspaper (www.thefarmceo.net), in addition to his FREE Weekly Public Speaking/Web Marketing IDEAS newsletter - which he uses to promote Burt Dubin's Public Speaking Mentoring service to experts across the African continent.
Visit Tayo's Flagship Performance Improvement website to download over 10 performance improvement resources to boost your personal and work related productivity.
Join Tayo's international community of fans on his Flagship MS Excel Heaven Facebook page (click here). You can also connect with him via Twitter (@tksola).
Warning: count(): Parameter must be an array or an object that implements Countable in /home1/tayoswdg/public_html/sdnuggets/wp-includes/class-wp-comment-query.php on line 399