ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   safely open file (https://www.excelbanter.com/excel-programming/310110-safely-open-file.html)

C Williams

safely open file
 
Hi.

If I have just uploaded an Excel file to my computer from a user, I
would like to use code to open it and scan it for some information
without risk of infecting my computer with a virus or similar problem.

Is there a way to open the file with the disable macros option? Will
this leave me "safe" from viruses, or are there additional steps necessary?

Alternatively, does anyone know of any antivirus software that makes a
library available so that I could scan the file before opening it?

Thanks in advance!

-Casey

Tom Ogilvy

safely open file
 
Hold down the shift key while you open the file

or before opening
Turn security to High on Tools =Macro=Security (I believe is the
location).

--
Regards,
Tom Ogilvy

"C Williams" wrote in message
news:wx72d.6699$yJ3.286@trndny08...
Hi.

If I have just uploaded an Excel file to my computer from a user, I
would like to use code to open it and scan it for some information
without risk of infecting my computer with a virus or similar problem.

Is there a way to open the file with the disable macros option? Will
this leave me "safe" from viruses, or are there additional steps

necessary?

Alternatively, does anyone know of any antivirus software that makes a
library available so that I could scan the file before opening it?

Thanks in advance!

-Casey




C Williams

safely open file
 
Thanks--but I guess I didn't make it clear I am looking for a way to do
that through code.

Thanks!

Tom Ogilvy wrote:
Hold down the shift key while you open the file

or before opening
Turn security to High on Tools =Macro=Security (I believe is the
location).



All times are GMT +1. The time now is 12:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com