Hi - I am trying to write a macro that works with the components in the VBA
project (the IDE), I have added the following reference - Microsoft Visual
Basic for Applications Extensibility 5.3. However whenever I make a
reference to the VBProject I get an error message.



For example the following code



Dim VBP As VBProject

Set VBP = ActiveWorkbook.VBProject



Generates the error below -



Run-time error '1004'



Method 'VBProject' of object'_Workbook' failed



Any suggestions much appreciated,



JS