Article ID: 932214
Article Last Modified on 3/7/2007
APPLIES TO
- Microsoft SQL Server 2005 Analysis Services
INTRODUCTION
This article describes the requirements to use Microsoft Excel Visual Basic for Applications (VBA) functions in Multidimensional Expression (MDX) queries in Microsoft SQL Server 2005 Analysis Services.
MORE INFORMATION
If you want to use Excel VBA functions such as ROUNDDOWN in MDX queries in SQL Server 2005 Analysis Services, you must install the following Microsoft Office features:
- Office Excel
- Microsoft Visual Basic for Applications
Note Visual Basic for Applications is a shared feature in Office.
REFERENCES
For more information about how to install and to repair Office 2003 features, click the following article number to view the article in the Microsoft Knowledge Base:
821593 How to install or repair and reinstall Office 2003 programs and features
For more information about how to install and to repair 2007 Office features, click the following article number to view the article in the Microsoft Knowledge Base:
924611 How to install and to repair 2007 Office features
Keywords: kbexpertiseinter kbsql2005as kbsetup kbhowto kbinfo KB932214