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
PS: For details of how to join my Excel-VB Club, read PII 005: You Need Excel-VB Coding Skills to MAKE and SAVE Money [Attend Tayo Solagbade’s FREE 4 Hour “Practical Introduction to MS Excel-VB Automation” Workshop]
You’re reading How can a “Switchboard” Make Your Life Easier in an MS Excel-VB driven Corporate Data Management/Report Generation System ? [Download A Useful Infographic] by Tayo Solagbade, originally posted on his Daily Self-Development (SD) Nuggets™ blog. If you loved reading this post, be sure to follow Tayo on Twitter, Facebook, and Google+.
You may also wish to check out his growing library of tutorial and demonstration videos on Youtube. Click here, to download over 10 resources to boost your personal and work related productivity.
IMPORTANT NOTE:
On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), was taken over by Aplus.net. Within a few days however, Tayo used his advanced self-taught web development skills to build (and move his website contents into) a SUPERIOR “reincarnation” at http://www.tayosolagbade.com.
Most URLs bearing the old domain name appearing in search engines should now work if “spontaneousdevelopment.com” is replaced with “tayosolagbade.com”. If you experience any difficulties finding a page or document, email Tayo at tksola dot com.
Click “Tayo, What Happened to SpontaneousDevelopmentDotCom?” to read a detailed narrative about how the above event occurred :-))
Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:
Succeed by Emerging from Adversity Like a Phoenix (TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)
And he wrote the one below, to explain why losing a domain name, no matter how old NO LONGER determines your online success or otherwise:
A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name
Source: ExcelVB
