Excel VBA on downloaded spreadsheets

[Colin Jex]

I have some problems about running Excel macros on
spreadsheets downloaded from the internet. I would be very
grateful if you could give me some advice. This link
should give you an idea of what I am doing: -

http://www.lums3.lancs.ac.uk/dl/Excel/EWMA Moving%
20Update.xls

The problem I have is that this does not behave
consistently when run from other PCs than my own - e.g
sometimes the spinner does not work, though usually it
does!
There are similar problems on other spreadsheets and even
Powerpoint presentations don't always behave identically.

I don't really now how Windows is handling this situation -
maybe that would shed some light on the origin of the
problem and how to fix it.

 

[Patrick Molloy]

Given the sheer volume of viruses being sent as
attachments right now, I don't think anyone in their
right mind would open the file pointed to by your link.

One issue may be that when you build a workbook with
references to dll's, those same dll's may not be
available on other machines, or they they may be in a
different location - to ActiveX and other controls may
not work