Results 1 to 11 of 11

Virus scanner nuking module?? Not a threat, I swear!

Threaded View

Ouka Virus scanner nuking module??... 09-22-2015, 07:20 PM
skywriter Re: Virus scanner nuking... 09-22-2015, 07:36 PM
Ouka Re: Virus scanner nuking... 09-22-2015, 09:03 PM
Norie Re: Virus scanner nuking... 09-22-2015, 07:42 PM
Ouka Re: Virus scanner nuking... 09-22-2015, 08:54 PM
shg Re: Virus scanner nuking... 09-22-2015, 07:58 PM
Ouka Re: Virus scanner nuking... 09-22-2015, 08:01 PM
skywriter Re: Virus scanner nuking... 09-22-2015, 08:11 PM
Ouka Re: Virus scanner nuking... 09-22-2015, 08:49 PM
Norie Re: Virus scanner nuking... 09-22-2015, 10:26 PM
Ouka Re: Virus scanner nuking... 09-23-2015, 02:18 AM
  1. #1
    Forum Contributor
    Join Date
    06-02-2005
    Posts
    100

    Virus scanner nuking module?? Not a threat, I swear!

    See code below (commented out for your safety ), it's just a quick lines of code counter I picked up just to see how much of a novel I've written so far. I'm curious about what in particular is causing the problem.

    'Sub CountCodeLines()'    Dim VBCodeModule As Object
    '    Dim NumLines As Long, N As Long
    '    With ActiveWorkbook
    '          For N = 1 To .VBProject.VBComponents.Count
    '                Set VBCodeModule = .VBProject.VBComponents(N).CodeModule
    '                NumLines = NumLines + VBCodeModule.CountOfLines
    '          Next
    '    End With
    '    MsgBox "Total number of lines of code in the project = " & NumLines, , "Code Lines"
    '    Set VBCodeModule = Nothing
    'End Sub
    
    'original code by johnske  from http://xlvba.fr.yuku.com/topic/112/VBA-code-lines-count-number-of-lines-in-project#.VgHg-dJViko
    This is triggering our enterprise virus scan as detecting "X97M/Generic@MM"

    The cleaning action nukes the entire module that the code is located on.

    I've confirmed that this sole block of code is causing the problem, as I have broken each chunk of code out and put it in their own document and then let the auto-scan do its thing. It only wipes the file that has this chunk in it.

    Can anyone help me understand what is causing the scanner to freak out and if there is syntax I can change to avoid this happening in the future?

    also asked here:
    http://www.mrexcel.com/forum/excel-q...ml#post4288803
    Last edited by Ouka; 09-22-2015 at 09:04 PM. Reason: crosspost link

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Virus scanner going wild on Excel Tips!
    By Runescope in forum Excel General
    Replies: 0
    Last Post: 04-28-2009, 02:38 PM
  2. [SOLVED] Macro Speed and Virus Scanner Installed.
    By Steven in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2006, 10:50 AM
  3. [SOLVED] SUMPRODUCT is broken (I swear!)
    By brandonc in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-30-2006, 07:00 PM
  4. [SOLVED] how do I turn off Virus Scanner?
    By Techware in forum Excel General
    Replies: 0
    Last Post: 07-31-2005, 10:05 PM
  5. [SOLVED] Can't open any files due to my non-existant virus scanner
    By Jay in forum Excel General
    Replies: 1
    Last Post: 07-03-2005, 03:05 PM
  6. virus scanner has blocked this file
    By nishak in forum Excel General
    Replies: 1
    Last Post: 06-24-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1