+ Reply to Thread
Results 1 to 11 of 11

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

  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.

    Please Login or Register  to view this content.
    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

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

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

    Just a shot in the dark. Have you tried setting up more objects. Like maybe the workbook wkb assigned and set to activeworkbook, maybe one for vbproject. Stranger things have worked.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

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

    That code is programatically accessing the VBE, and though it's only counting the no of lines in each project, your virus scanner
    could be picking up the syntax as something that's possibly malicious.

    Why not just store the code in a text file?

    Then when you want to run it import it into the current project, run it and deleting once you are finished with it.

    Not ideal I know but not too much hassle.
    Last edited by Norie; 09-22-2015 at 08:05 PM.
    If posting code please use code tags, see here.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

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

    Cross-posted at http://www.mrexcel.com/forum/excel-q...e-counter.html

    That's a good way to lose friends.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Contributor
    Join Date
    06-02-2005
    Posts
    100

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

    sorry, there a site rivalry I'm not aware of? I pop onto both on occasion when I have a problem, then try and answer some questions to repay for the help I get.

  6. #6
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

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

    sorry, there a site rivalry I'm not aware of?
    No that's not the issue. Many people here post on many sites, that's probably how you got caught.


    Read this to understand why we ask you to make us aware of your cross post and provide a link to any other sites.

  7. #7
    Forum Contributor
    Join Date
    06-02-2005
    Posts
    100

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

    ah ok. wasn't ware it was a problem. will keep it in mind for the future.

  8. #8
    Forum Contributor
    Join Date
    06-02-2005
    Posts
    100

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

    Quote Originally Posted by Norie View Post
    Why not just store the code in a text file?
    is there a way to grab all text from all modules, sheets, and forms and dump it all into a text file (without using whatever offended the scanner in the above code)? My project has code *everywhere*, approaching 20,000 lines =P

  9. #9
    Forum Contributor
    Join Date
    06-02-2005
    Posts
    100

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

    Quote Originally Posted by skywriter View Post
    Just a shot in the dark. Have you tried setting up more objects. Like maybe the workbook wkb assigned and set to activeworkbook, maybe one for vbproject. Stranger things have worked.
    doesn't seem to make much of a difference but I'll keep trying. Problem is I can't control when the scanner decides to check my files. Seems kinda random. 5 minutes to 5 hours between warnings. Hard to tell if something worked or if I'm just between scan cycles

    shg recommended switching scanners on the other forum, but sadly it's an enterprise-mediated tool that's under 4 or 5 different IT service layers. I'll never be able to get a hold of someone that can actually change a setting in the scanner for my system =P

  10. #10
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

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

    Ouka

    That's not really what I was meaning.

    I was suggesting keeping the code that counts the no of lines in a text file and import it whenever you need it.

  11. #11
    Forum Contributor
    Join Date
    06-02-2005
    Posts
    100

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

    ahhh gotcha. ^_^ yeah, that's what I've done. And I put it into an empty module when using it. I discovered the problem when the virus scanner nuked the module I was working on, while I was in it. So now if it nukes me while I've got the file open I just lose that one, otherwise empty module.

+ Reply to Thread

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. 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. SUMPRODUCT is broken (I swear!)
    By brandonc in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-30-2006, 07:00 PM
  4. how do I turn off Virus Scanner?
    By Techware in forum Excel General
    Replies: 0
    Last Post: 07-31-2005, 10:05 PM
  5. Replies: 1
    Last Post: 07-03-2005, 03:05 PM
  6. [SOLVED] 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