+ Reply to Thread
Results 1 to 4 of 4

guarantee virus-free macro?

  1. #1
    Registered User
    Join Date
    05-04-2010
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    guarantee virus-free macro?

    Hi folks - need advice. I work for a research company which has contracts with the government to collect data from schools. In the past, we have offered a web based data collection option or a flat file uploading option to give us our data. The flat file option required a programmer to produce it. This year, we'd like to offer the option of having the respondent use a macro-enabled spreadsheet to give us our data. The macros would verify good data, do QC checks, etc.

    I am worried that many schools will not let folks enable the macros unless we could give them some sort of guarantee that there weren't lurking viruses in the spreadsheet. Is there a way to do this? Is there a 3rd party tool that could scan the spreadsheet and guarantee that it was virus-free? I also don't want to scare them into worrying about it, but for those who are worried up front, I thought maybe there'd be something we could do.

    thanks in advance!

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: guarantee virus-free macro?

    Quote Originally Posted by rasmuscm View Post
    Is there a 3rd party tool that could scan the spreadsheet and guarantee that it was virus-free?
    Their anti-virus software?
    Remember what the dormouse said
    Feed your head

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

    Re: guarantee virus-free macro?

    Get a digital certificate from VeriSign. It's your company's formal, verifiable representation that the code is free of malware.

    https://www.verisign.com/code-signin...html?sl=header
    Last edited by shg; 05-04-2010 at 10:31 AM.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    05-04-2010
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: guarantee virus-free macro?

    Quote Originally Posted by shg View Post
    Get a digital certificate from VeriSign. It's your company's formal, verifiable representation that the code is free of malware.

    https://www.verisign.com/code-signin...html?sl=header
    Thanks much! I didn't realize VeriSign was also for VBA stuff.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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