fredlo2010
10-08-2014, 06:32 AM
Hello,
I am trying to create a code that uses the VBIDE but I cound it make it work with late biding.
Any ideas? This is my code below.
Option Explicit
Sub Sample()
Dim VBProj As Object
Dim VBComp As Object
' Create the objects. THis si the part with the error.
Set VBProj = CreateObject("VBIDE.VBProject")
Set VBComp = CreateObject("VBIDE.VBComponent")
Set VBProj = ActiveWorkbook.VBProject
Set VBComp = VBProj.VBComponents("a_Module")
End Sub
Thanks
I am trying to create a code that uses the VBIDE but I cound it make it work with late biding.
Any ideas? This is my code below.
Option Explicit
Sub Sample()
Dim VBProj As Object
Dim VBComp As Object
' Create the objects. THis si the part with the error.
Set VBProj = CreateObject("VBIDE.VBProject")
Set VBComp = CreateObject("VBIDE.VBComponent")
Set VBProj = ActiveWorkbook.VBProject
Set VBComp = VBProj.VBComponents("a_Module")
End Sub
Thanks