Dim vbcomponent As Variant
Sub exportForm()
On Error Resume Next
Dim wbSource As Workbook, wbDestination As Workbook
Set wbSource = Workbooks.Open("C:\abc\DIR\Desktop\Book1")
Set wbDestination = ThisWorkbook
For Each vbcomponent In wbSource.VBProject.VBComponents
If (vbcomponent.Name = "displayForm") Then
wbSource.VBProject.VBComponents(vbcomponent.Name).Export "C:\temp\displayForm.frm"
wbDestination.VBProject.VBComponents.Import "C:\temp\displayForm.frm"
End If
Next
Kill "C:\temp\displayForm.frm"
Kill "C:\temp\displayForm.frx"
wbSource.Close
End Sub
Sub exportForm()
On Error Resume Next
Dim wbSource As Workbook, wbDestination As Workbook
Set wbSource = Workbooks.Open("C:\abc\DIR\Desktop\Book1")
Set wbDestination = ThisWorkbook
For Each vbcomponent In wbSource.VBProject.VBComponents
If (vbcomponent.Name = "displayForm") Then
wbSource.VBProject.VBComponents(vbcomponent.Name).Export "C:\temp\displayForm.frm"
wbDestination.VBProject.VBComponents.Import "C:\temp\displayForm.frm"
End If
Next
Kill "C:\temp\displayForm.frm"
Kill "C:\temp\displayForm.frx"
wbSource.Close
End Sub
No comments:
Post a Comment