Browse by Tags
All Tags »
VBA (RSS)
There is an interesting post in the VSTO forum about VBA/VSTO/VSTA. The question is: "Is VSTO/VSTA intended to replace VBA?" http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1461382&SiteID=1 The future of VBA and VSTO/VSTA's role continues to
Read More...
There really isn't a lot of advice out there on how to approach migrating to VSTO. I came to VSTO from the perspective of a long time Office VBA developer. For me, the things I spent the most time on were developing an understanding of .NET/COM interoperability
Read More...
Recently a friend of mine asked me for help with a data management issue. Same story, different day - he had numerous Excel files (about 8-10 he tells me) with sales prospects that he needed to combine and clean. This friend is former professional water
Read More...
How do I retrieve the login name of the current user in Excel or VBA? This has to be one of the most common questions asked by people building Office-based applications. Though Charles covered it pretty throughly a couple of years ago, I thought I'd give
Read More...
There are a lot of authors (some with books in the works) that maintain blogs that grace the pages of OfficeZealot.com including Chris Webb (book in the works), Mauro Cardarelli (book in the works), Ed Bott , Eric Carter , Andrew Whitechapel and yes,
Read More...