Importing a userform to an new worksheet vba

[toughie]

[FONT=Verdana]Set wb = Workbooks.Add
    ThisWorkbook.Activate
    ActiveSheet.Copy Before:=wb.Sheets(1)
    wb.Activate
    Workbooks("Copy of TEST2 - Copy.xlsm").Close
    [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Dim path As String
    Dim fileName As String
    path = "C:\Users\andy_\OneDrive\Desktop\VAMLog\"
    fileName = "SAVEPDF.frm"
    ThisWorkbook.VBProject.VBComponents.Import path & fileName[/FONT][/FONT]

Im trying to get the SAVEPDF.frm to import into the new worksheet but its not working, any ideas?

its not throwing up an error, stuck now with no clues

any help appreciated?

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...a-export-module-new-workbook.html#post5232560

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).