While working with SharePoint VPC Image I got an error when I imported an Excel file for a custom list. The error says

"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

The reason this error occurs is because VBA is not installed. To fix this go to Add/Remove programs and click change for Microsoft Office Enterprise 2007. Office setup dialog will popup. Click on Add or Remove Features radio button and expand Office Shared Features and make Visual Basic for Applications to Run from My Computer. This should fix the problem.

Technorati Tags: SharePoint

1. First Look At Microsoft Cloud Computing
2. Important SharePoint Updates Released
3. SharePoint / MOSS Books
4. Visual Studio 2008 Extensions For Windows SharePoint Services
5. SharePoint and Sarbanes-Oxley

This entry was posted on Wednesday, July 16th, 2008 at 10:13 am and is filed under SharePoint. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.