Consulting

Results 1 to 2 of 2

Thread: Disable Virus Scanner Check?

  1. #1

    Disable Virus Scanner Check?

    Is there any way of disabling the virus scanning before opening every excel document on the vba macro level? i know i can turn it off in the antivirus program, but i want it to be trasparent to the user if at all possible.

    i assume the scan kicks in before any macro is ever executed...so what can i do? i need to open a bunch of files with this code and it takes 3sec+ to open each file. the user could be waiting for 30sec+ on something that shouldn't take longer than 5sec!

  2. #2
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    I'm sure that this depends on many things, including the virus scanner in use, but...

    The point of having a virus check before opening files is to prevent malicious code from running. If you could just unflag the settings by using VBA or some other language, what would the point of the protection be? I would suspect that no virus software would allow programatic access to their object model, and if I found out mine did, I would remove it immediately.

    It is also worth noting that while you ask this question, anyone can read the response... including someone who wants to learn to do this with nefarious intent.
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





Posting Permissions

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