CDXStreamer Does Not Work in Excel 2007

You need to install VBA with Office 2007 for CDXStreamer work. Office 2007 is the only Office that does not do this by default. CDXStreamer formulas will return #Name? unless VBA is installed.

To install VBA with the 2007 Microsoft Office system

  1. In Control Panel, run Add or Remove Programs or Programs and Features.
  2. Select Office in the Currently installed programs list.
  3. Click Change.
  4. Select Add or Remove Features, and then click Continue.
  5. Select Choose advanced customization of applications, and then click Next.
  6. Expand Office Shared Features in the Choose update options for applications and tools list.
  7. Open the drop-down menu next to Visual Basic for Applications, and then click Run from My Computer.
  8. Click Continue.
  9. Click Close.