Programming IDE

  • Thread starter Thread starter JS
  • Start date Start date
J

JS

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
 
Back
Top