+ Reply to Thread
Results 1 to 6 of 6

Macros & Fsecure

  1. #1
    Registered User
    Join Date
    10-30-2021
    Location
    Copenhagen area, Denmark
    MS-Off Ver
    365
    Posts
    14

    Macros & Fsecure

    I have an Excel project with a lot of VBA macros.
    I've just added a macro to save attachments from Outlook in a folder - and now Fsecure believes my Excel file is dangerous and puts it in quarantine.
    The funny thing is, an Excel file with ONLY this macro in it is OK, and an Excel file with all my OTHER macros in it is OK. Among the other macros is one to execute DOS commands.
    I copy-paste the macros via a text editor, so it's NOT - I believe - because some foreign code sneaks in without me noticing it.
    Fsecure is using "heuristics", and I suppose it works a bit like a spam filer: Any file will score points based on several different criteria, and if it exceeds a treshold, it will be deemed dangerous.
    I could post my macros here, but what I really want to know is, do anyone have guidelines, do's and don'ts, about this? Or similar experiences? In the end, my Excel project will be used by others, and I do not know what security software they will have.

  2. #2
    Registered User
    Join Date
    10-30-2021
    Location
    Copenhagen area, Denmark
    MS-Off Ver
    365
    Posts
    14

    Re: Macros & Fsecure

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-30-2021
    Location
    Copenhagen area, Denmark
    MS-Off Ver
    365
    Posts
    14

    Re: Macros & Fsecure

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    10-30-2021
    Location
    Copenhagen area, Denmark
    MS-Off Ver
    365
    Posts
    14

    Re: Macros & Fsecure

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-30-2021
    Location
    Copenhagen area, Denmark
    MS-Off Ver
    365
    Posts
    14

    Re: Macros & Fsecure

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    10-30-2021
    Location
    Copenhagen area, Denmark
    MS-Off Ver
    365
    Posts
    14

    Re: Macros & Fsecure

    So I've stripped down the offending code to the four sections posted above. Combining these four, and no other content, in a VBA module, results in an Excel file that Fsecure promptly removes. Leaving out ANY of the four sections makes the file palatable to Fsecure. Section 4, in particluar, should in my opinion be of absolutely no relevance to Fsecure, so I think (once other aspects of the macro cause concern) the AMOUNT of code in itself contributes to the score that makes Fsecure reject my file. (Also, simplifying Section 2 (harvesting mail attachments) so that it still does exactly the same thing, but without keeping track of attachment filename extensions that I skip, makes it OK.)

    It's all pretty annoying! Does anyone have any ideas how to move on with my project? I need to download attachments (Section 2), to execute a DOS command (Section 1), and a lot more (Sections 3 and 4 are just a small sample)? I do have an idea: Move the harvesting to a separate Excel project that does this, and nothing else. I think that would work for me. But ... might Fsecure (or other malware detection software) still kill my whole project next time they update sth? (I THINK Fsecure accepted an essentially equivalent xlsm file early January; I only got into trouble this week!)

+ 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. [SOLVED] Sort Operation Works when Macros are called manually, but not when VBA calls the Macros
    By lovecolorado in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2019, 02:13 PM
  2. Multiple macros for several files that change weekly - where to store macros
    By janljan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-21-2018, 10:54 PM
  3. Replies: 2
    Last Post: 04-13-2017, 02:57 AM
  4. Cant hide worksheets after macros to force users to enable macros
    By Mboemoyo85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2015, 02:52 AM
  5. Replies: 0
    Last Post: 06-09-2015, 09:30 PM
  6. Replies: 1
    Last Post: 10-02-2013, 09:05 PM
  7. [SOLVED] choose default macros Not Enabled / Macros Enable Setting
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2006, 08:10 AM

Tags for this Thread

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