When I download the file and THEN scan with Avast, I would expect Avast to pick up the virus, no differently than if I got a virus file on a CD or floppy disk, no?
Where the file is (CD, floppy, attached in an email...) is not relevant, but the way you scan (deeper or not) the file.
