| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop Symantec AV from quarantine my VBA
Excel 2003 up to date
What type of commands in Excel VBA does NAV assume relate to the Bloodhound Macro Virus. I assume that it does not like any command that deletes files - but there may be others. Can anyone help me strip my Personal.xls of VBA commands which causes NAV to delete the file? Any ideas? Plea..........se! EagleOne |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop Symantec AV from quarantine my VBA
It dislikes any use of the VBIDE extensibility - changing code with code is a hallmark of document
viruses. You can set NAV Bloodhound feature to ignore certain files or folders - not sure how, but my IT department was able to protect my files from being deleted. HTH, Bernie MS Excel MVP "EagleOne@microsoftdiscussiongroups" crosoft.com wrote in message ... Excel 2003 up to date What type of commands in Excel VBA does NAV assume relate to the Bloodhound Macro Virus. I assume that it does not like any command that deletes files - but there may be others. Can anyone help me strip my Personal.xls of VBA commands which causes NAV to delete the file? Any ideas? Plea..........se! EagleOne |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop Symantec AV from quarantine my VBA
Thanks Bernie.
My IT department makes no exceptions, so far. Would you mind being a bit more specific changing code with code; just an example or two. Further, I will demonstrate my relative VBA inexperience as to - VBIDE extensibility? I thought the problem was related to file delete commands. "Bernie Deitrick" wrote: It dislikes any use of the VBIDE extensibility - changing code with code is a hallmark of document viruses. You can set NAV Bloodhound feature to ignore certain files or folders - not sure how, but my IT department was able to protect my files from being deleted. HTH, Bernie MS Excel MVP "EagleOne@microsoftdiscussiongroups" crosoft.com wrote in message ... Excel 2003 up to date What type of commands in Excel VBA does NAV assume relate to the Bloodhound Macro Virus. I assume that it does not like any command that deletes files - but there may be others. Can anyone help me strip my Personal.xls of VBA commands which causes NAV to delete the file? Any ideas? Plea..........se! EagleOne |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop Symantec AV from quarantine my VBA
You can use code like this to add VBA code to a workbook:
Sub AddMeanModuleAndWickedProcedure() Dim newVBComp As VBComponent Set newVBComp = ActiveWorkbook.VBProject.VBComponents.Add(vbext_ct _StdModule) newVBComp.Name = "ReallyDangerousCode" With newVBComp.CodeModule .InsertLines .CountOfLines + 1, _ "Sub myKillerSub()" & Chr(13) & _ " Msgbox ""Hello There, I'm about to destroy your computer.... HA HA HA HA!!!!"" " & Chr(13) & _ "End Sub" End With End Sub It requires a reference to the MS VBA Extensibility X.X (Sorry, I mis-spoke when I said VBIDE Extensibility) to work, and this was the basis of that Word virus that made headlines 5 years or so ago. You can see where adding code to workbooks can be problematic, especially if the code is written in a way that it writes itself into all open workbooks, which then write code to.... Bloodhound may also look for file deletion or kill commands.. I'm not certain of what it looks for, but I lost lots of code like that above when I was writing a utility that would update the code in files created from a template.... HTH, Bernie MS Excel MVP "EagleOne@microsoftdiscussiongroups" rosoft.com wrote in message ... Thanks Bernie. My IT department makes no exceptions, so far. Would you mind being a bit more specific changing code with code; just an example or two. Further, I will demonstrate my relative VBA inexperience as to - VBIDE extensibility? I thought the problem was related to file delete commands. "Bernie Deitrick" wrote: It dislikes any use of the VBIDE extensibility - changing code with code is a hallmark of document viruses. You can set NAV Bloodhound feature to ignore certain files or folders - not sure how, but my IT department was able to protect my files from being deleted. HTH, Bernie MS Excel MVP "EagleOne@microsoftdiscussiongroups" crosoft.com wrote in message ... Excel 2003 up to date What type of commands in Excel VBA does NAV assume relate to the Bloodhound Macro Virus. I assume that it does not like any command that deletes files - but there may be others. Can anyone help me strip my Personal.xls of VBA commands which causes NAV to delete the file? Any ideas? Plea..........se! EagleOne |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop Symantec AV from quarantine my VBA
Outstanding answer!! Thanks
"Bernie Deitrick" wrote: You can use code like this to add VBA code to a workbook: Sub AddMeanModuleAndWickedProcedure() Dim newVBComp As VBComponent Set newVBComp = ActiveWorkbook.VBProject.VBComponents.Add(vbext_ct _StdModule) newVBComp.Name = "ReallyDangerousCode" With newVBComp.CodeModule .InsertLines .CountOfLines + 1, _ "Sub myKillerSub()" & Chr(13) & _ " Msgbox ""Hello There, I'm about to destroy your computer.... HA HA HA HA!!!!"" " & Chr(13) & _ "End Sub" End With End Sub It requires a reference to the MS VBA Extensibility X.X (Sorry, I mis-spoke when I said VBIDE Extensibility) to work, and this was the basis of that Word virus that made headlines 5 years or so ago. You can see where adding code to workbooks can be problematic, especially if the code is written in a way that it writes itself into all open workbooks, which then write code to.... Bloodhound may also look for file deletion or kill commands.. I'm not certain of what it looks for, but I lost lots of code like that above when I was writing a utility that would update the code in files created from a template.... HTH, Bernie MS Excel MVP "EagleOne@microsoftdiscussiongroups" rosoft.com wrote in message ... Thanks Bernie. My IT department makes no exceptions, so far. Would you mind being a bit more specific changing code with code; just an example or two. Further, I will demonstrate my relative VBA inexperience as to - VBIDE extensibility? I thought the problem was related to file delete commands. "Bernie Deitrick" wrote: It dislikes any use of the VBIDE extensibility - changing code with code is a hallmark of document viruses. You can set NAV Bloodhound feature to ignore certain files or folders - not sure how, but my IT department was able to protect my files from being deleted. HTH, Bernie MS Excel MVP "EagleOne@microsoftdiscussiongroups" crosoft.com wrote in message ... Excel 2003 up to date What type of commands in Excel VBA does NAV assume relate to the Bloodhound Macro Virus. I assume that it does not like any command that deletes files - but there may be others. Can anyone help me strip my Personal.xls of VBA commands which causes NAV to delete the file? Any ideas? Plea..........se! EagleOne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Changes | Excel Discussion (Misc queries) | |||
| How To Stop #Div | Excel Worksheet Functions | |||
| Stop (C) becoming © | Excel Discussion (Misc queries) | |||
| How do I stop other circles in other cells to stop selecting? | Excel Worksheet Functions | |||
| How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions | |||
Hybrid Mode
