Why is this so ?
Hi Halim
I just gave it a try and changed the *frm to *.txt and it still came up with
the virus alert.
Jason
" wrote:
Hi Jason,
I posted that code, but in my computer I use Virus protector too
and not indicates that codes result as a virus or harmed thing.
But anyway see your virus protector, likely the virus protector has
been indicated a new file object ort item in a Operating Systems
as a virus if not from trusted source!. Check your Virus protector
properties. ..
Maybe *.Frm as a new VIRUS for your Virus protector
Thanks,
Halim
Jason Zischke menuliskan:
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
|