Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why is this so ?
Hi all,
I found this code that exports, Removes & imports forms, modules & class modules however I can't seem to get the remove to work and when I go to save the workbook my virus protector sees it as a threat or a possible virus so it then prohibits excel from saving. See below for the code and any help would be greatly appreciated. Sub TestExportForm() ThisWorkbook.VBProject. _ VBComponents("Userform1").Export "C:\Userform1.frm" ThisWorkbook.VBProject.VBComponents.Remove "Userform1" End Sub Sub TestImportForm() ThisWorkbook.VBProject.VBComponents.Import "C:\Userform1.frm" End Sub Jason |