Programming IDE

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed 15
Programmatically Adding a Worksheet_Change Event Procedure to a Pr 5
This request for the very experts. Please reply at the earliest 1
Online Help on VBIDE 3
avoid reset after CodeModule InsertLines 8
VBA code syntax to protect/unprotect VBProject asumming if Password is known. 3
Protect current VBA Project? 4
Delete all code in VBA module - error? 2

Top