Browse by Tags
All Tags »
VBA »
Excel (RSS)
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...
In Part I , I discussed how to set the worksheet up, now it’s time to look at some code. Building a report consists of three logical operations: determining the correct MDX that will yield the desired results, fetching the data, and displaying the
Read More...
The main objectives in this post are to show some screenshots that demonstrate what you can expect when you complete the exercise and to do all of the preliminary setup on the workbook. The goal of this example is to show how you can create reports in
Read More...