tag:blogger.com,1999:blog-22389180.post8260014799092763643..comments2023-07-20T07:10:39.352-04:00Comments on Bringing Closure: VBA and VSTODon Spencerhttp://www.blogger.com/profile/09812331053850930421noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-22389180.post-55613538882816119932009-07-20T12:01:43.441-04:002009-07-20T12:01:43.441-04:00Don't forget in all of this the amateur user. ...Don't forget in all of this the amateur user. I use VBA to develop a lot of personal productivity tools for Word, helping me manage complex document etc more effectively.<br /><br />Visual Studio and VSTO are far too expensive for an amateur user, and Visual Studio express does not include any support for Add-ins, so the poor old amateur user is left high and dry if VBA goes.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-22389180.post-65753586782802748452008-03-28T06:53:00.000-04:002008-03-28T06:53:00.000-04:00I totally agree with you and have exact the same f...I totally agree with you and have exact the same feelings about how MS treats this issue. Exciting though is what I saw at Tech Ed in Barcelona Nov 2007. There was a nice demonstration of an internal MS application called "Rhytm of Business". MS have tried to build a new BI-application replacing an old VBA-version based on their new stuff including Excel-services. They had to give up and install the Excel-client on the user’s machine due to lack of features in Excel-services to satisfy the user requirements. They also had some hidden VBA in the new system but they have managed to call it from VTSO and by other ways, so they reuse their old investment which is what my customers also want to do. I hope and think that this lesson will teach MS that they sit with VBA forever so the better make it vital again as they have done with JET. I am convinced this will happen, the Office-share of MS income is to big to neglect forever, then someone will come up and steal it...<BR/>Rickard Olsson<BR/>Sweden<BR/>http://xlrocks.wordpress.com/Rickardhttps://www.blogger.com/profile/12249408270226213744noreply@blogger.com