We have recently upgraded our office products. I have been use a macro that
goes out to a file on a server and opens the file then populates some cells
prints the sheet and then closes excel. The problem is now with 2003 I get
this strange warning when the macro opens the file.
"Some files can contain viruses or otherwise be harmful to your computer.It
is important that the file is from a trustworthy source.
Any one have any idea how I stop this from happening?
>We have recently upgraded our office products. I have been use a macro that
>goes out to a file on a server and opens the file then populates some cells
>prints the sheet and then closes excel. The problem is now with 2003 I get
>this strange warning when the macro opens the file.
>
>"Some files can contain viruses or otherwise be harmful to your computer.It
>is important that the file is from a trustworthy source.
>
>
>
>Any one have any idea how I stop this from happening?
>
>TIA
>Josh
>
In 2002 there is an option under:
Tools/Options/Security/Macro Security
where you can turn this warning off.
BUT, be sure to read about macro security and viruses so you can be sure that
turning it off is the correct thing to do.
--ron
Excel Programming >> RE: VBA problem
In 2003 all I can see to do is set it to low. and that does not seem to
work. Any other ideas? Thank you
Josh
>
>>We have recently upgraded our office products. I have been use a macro
>>that
>>goes out to a file on a server and opens the file then populates some
>>cells
>>prints the sheet and then closes excel. The problem is now with 2003 I get
>>this strange warning when the macro opens the file.
>>
>>"Some files can contain viruses or otherwise be harmful to your
>>computer.It
>>is important that the file is from a trustworthy source.
>>
>>
>>
>>Any one have any idea how I stop this from happening?
>>
>>TIA
>>Josh
>>
>
> In 2002 there is an option under:
>
> Tools/Options/Security/Macro Security
>
> where you can turn this warning off.
>
> BUT, be sure to read about macro security and viruses so you can be sure
> that
> turning it off is the correct thing to do.
> --ron
Excel Programming >> RE: VBA problem
I don't think it's a macro problem. I think it's because you are
opening an Excel file that isn't on your computer.
Have you ever clicked on an Excel or Word document link on the
internet? It gives you the option of saving it or opening it directly.
If you open it directly, you'll get the prompt you described above.
It sounds like Excel 2003 doesn't think the network server is in the
trusted zone.
One possible workaround would be to change the script to:
- copy the file to a local directory
- open the local copy
- make the changes
- save it back to the original directory
If you can't solve this another way, it's worth a shot.
Excel Programming >> RE: VBA problem
I have found that on my computer it works fine but on the new computer it
does not. here is the code. I feel that it must have to do something with the
security settings? I can prdoduce this error by this code.
> I don't think it's a macro problem. I think it's because you are
> opening an Excel file that isn't on your computer.
>
> Have you ever clicked on an Excel or Word document link on the
> internet? It gives you the option of saving it or opening it directly.
> If you open it directly, you'll get the prompt you described above.
>
> It sounds like Excel 2003 doesn't think the network server is in the
> trusted zone.
>
> One possible workaround would be to change the script to:
> - copy the file to a local directory
> - open the local copy
> - make the changes
> - save it back to the original directory
>
> If you can't solve this another way, it's worth a shot.
>
> -----
> Nick Hebb
> BreezeTree Software
> http://www.breezetree.com
>
>