Vba Vbe Export

Coby · January 23rd, 2008, 06:36 PM

Does anyone know how to remove the entire vba project (vbe) from one workbook?

Then, load it into another workbook on its workbook open event?

Thanks for any help you could give me.

Coby.

Shasur · January 23rd, 2008, 10:43 PM

You can try to Export the Components and then Import it to another workbook

Here is the hint

Code:

Sub VBE_Pjt()

Dim VBPjt As VBProject
Dim oWB As Workbook
Dim oVBC As VBComponent
Set oWB = Workbooks("MyExample.XLS")
Set VBPjt = oWB.VBProject
For Each oVBC In VBPjt.VBComponents
    oVBC.Export "c:\mytemp\" & oVBC.Name
Next oVBC
'' Loop for all the files
VBPjt.VBComponents.Import "c:\mytemp\mlinkfix"

End Sub

You need to add reference to Visual Basic Extensibility for executing the above code.

Also try VBPjt.SaveAs if it works for you

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Coby · January 25th, 2008, 04:40 PM

Thanks, That approach will work for what I am doing!