MSP 'Compile error: Variable not defined'
search cancel

MSP 'Compile error: Variable not defined'

book

Article ID: 124411

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Opening / Launching a Project in Microsoft Project (MSP) via the Clarity MSP Integration throws a VBA error message (debug pages pops up):

Error:  'Compile error: Variable not defined.'

Steps to Reproduce:

  1. Open a project in Clarity
  2. Click 'Open in Scheduler'
  3. Click Microsoft Project [Read-Write]

Expected Results: Project opens in MSP without error

Actual Results: Receive error message: 'Compile error: Variable not defined.'

Environment

Release: All Releases

Component: CLARITY MICROSOFT PROJECT (MSP) Connector

All browsers including Internet Explorer (IE) and Chrome

Cause

This can happen if the modules are showing with incorrect name in View > Macros > Visual Basic 

In the screen shot below, there is a 1 at the end of the Modules name causing the issue:

Resolution

Rename the modules to the correct names using the steps below:

  1. Open MSP from the desktop or Start menu
  2. Open a blank project
  3. In MSP, go to View > Macros > Visual Basic 
  4. On the left hand window, expand ProjectGlobal then expand Modules
  5. Select each of the four modules starting with either CA_ or Niku_ (select one at a time)
  6. On the module Properties window right beneath the 'Project - ProjectGlobal' window, click on the Name under the 'Alphabetic' tab.
  7. Remove the 1 from the module name and click away. Do this for each of the four modules. 

   8. Go to File > Save Global.MPT

   9. Go to File > Save and Return to Microsoft Project 

Additional Information