|
Mon 7th April 2008 |
Issue No. 25
|
|||||||||||||||||||||||||||||||||
| Latest Tip! With
VSTO/VSTA Here, What's The Future Of VBA? ! Updates About SDAc's Activities/Tips You Can Use |
||||||||||||||||||||||||||||||||||
| I
build custom Excel-VB driven software used by a growing number of
individuals and businesses out here in Lagos, Nigeria. Over the past
five years in particular, I have successfully tailored the solutions I
offer to SUIT the local environment we have, in a way that appeals to
many results-focussed business users who are enthusiastic about using
Information Technology to IMPROVE the way they work. It is therefore only natural that such existing clients - and the prospective ones I approach - should wonder about the continuing relevance of the platform I use for developing and maintaining the solutions I provide them. This matter has become even more important since the first version of Visual Studio Tools for Office (VSTO)/Visual Studio Tools for Applications (VSTA) The first version has since been improved upon - and continues to get better. Discussions have raged among active members of the VBA community about how this new resource from Microsoft affects Visual Basic for applications (VBA) and its usefulness to end users. Here's what i think: For those who believe the "entry" of VSTO/VSTA" marked the end of VB for Excel, here's some advice: Don't count on it. The debates have continued even as Microsoft continues to roll out newer/richer featured versions of the new platform. One TRUTH that remains clear to all objective "viewers" is that except it wishes to commit financial suicide, Microsoft will continue to ensure VB for Excel functionality in newer versions of MS Excel it releases. I can attest to this being true because the Hotel, Restaurant & Bar Manager software i just built for a client was developed to run on MS Excel 2007 which is most recent version. All I did was to ensure its backward compatibility with lower versions down to MS excel 2000. The fact remains that many small businesses and departments in large corporations will continue to NEED the kinds of quick/easily developed and deployed solutions that VB for Excel allows. Of course, with VSTA getting better, more use is likely to be made of it, but I believe it remains critical that POWER still be left in the hands of end users as has been the case with VBA if maximum user benefits are to be derived. I say this because it is highly inconceivable that corporate IT departments today and in the future will EVER get to a point where they will be so LESS busy as to have time to cater for different departments' needs - in terms of developing rapid custom software solutions - on the scale that VB for Excel solutions allow. I will be publishing a much more detailed article on this subject later in the month. In that article, I will provide links to discussions amongst some prominent members of the VBA community, which includes professionals who have built custom Excel-VB driven software used by some of the world's largest corporations, including Microsoft itself. For now, visit a Microsoft forum to read entries relating to a post titled "Is VSTO/VSTA intended to replace VBA?" Visit Microsoft VBA Discussion forum |
||||||||||||||||||||||||||||||||||
| SD
Nugget : You
Need To Develop A Health Respect For Money Ideas To Help You Develop Yourself To Achieve Your FULL Potential |
||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||
|
Back in paid employment, I was, like
many of my co-workers, used to
having my salary paid to me in bulk at the month end (almost without
fail). I never really understood what it meant to EARN the money that
came to me. Don't get me wrong.
ON-DEMAND LEARNING EVENT: RAPID SPEECH PREPARATION COACHING Learn how to prepare text material for your speech in minutes rather than days. This is an excellent skill towards the inevitable short notice you WILL get as an expert or professional in your field or interest. I can show you how to get ALL you want/have to say condensed into ONE single A4 sheet of paper within a few minutes. This technique is one I have used very successfully as a speaker myself - so you can be sure it works. Call me on 0803-302-1263 for details.ON-DEMAND LEARNING EVENT: In-House Excel-VB Programming Coaching For Your Employees Minimise Expensive Software Purchase By Developing In-House Excel-VB Programming Expertise Among Your Staff. Your company can eliminate vital decision making delays due to IT personnel being overloaded for instance, by empowering “champion” employees within individual departments to quickly and easily develop solutions to that address the immediate business data analysis/reporting needs of their respective units. Other benefits of having In-House Excel-VB Solutions Development expertise: (a). It will provide temporary alternative to - or relieve pressure on - the IT department. (b). Provides users a useful/friendly development environment for new reports and analyses - which in turn enhances software needs definition - reducing software development or purchase costs. (c). Empowers employees to analyse company data to improve performance. It is my belief that just as I was able to develop over four(4) automated spreadsheet applications to solve real-life problems – in my spare time - as a non-IT staff in Guinness Nigeria Plc (read details on the about page at www.excelheaven.spontaneousdevelopment.com), your staff, if equipped with similar skills, can do the same for your company – and possibly help you AVOID expending scarce cash (1). buying expensive commercial software or (2). hiring "pricey" software developers. Click here to learn how I have built custom Excel-VB driven software for client companies for as much as N200,000.00(Proof Available). While there you can request/download my FREE MS Excel Coaching Skills Matrix workbook and a one-page Excel VB Programming Coaching Course Outline. Call 234-803-302-1263 to request further details.
|
||||||||||||||||||||||||||||||||||
|
|
|
|||||||||||||||||||||||||||||||||
| Online
Recommended Resource Links Resource URLs For Entrepreneurs, Employees, Parents, Teachers & Students |
||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||
|
Yours in Self-Development! Tayo K. Solagbade |
||||||||||||||||||||||||||||||||||