On 24 Apr, 18:41, Lynda wrote:
Wild guess here, but I'd put my money on it having to do with Vista's
built-in Big-Brother, er, I mean security features. Firewall or UAC settings,
maybe.

"TimP58" wrote:
I have a spreadsheet which I wrote some time ago for checking my
lottery results. The code is shown below and has worked perfectly on
a number of XPSP2 machines for quite some time. I have recently
upgraded my home PC to Vista 64 SP1 and installed my copy Office 2003
on it. Now when I try to run the VBA I get various errors when using
the SHDocVW functions

<snip

I have tried running Excel as Adminstrator but it doesn't make any
difference although I haven't tried disabling the UAC yet. Perhaps I
should have a go as web searches haven't come up with any other
answers. I did wonder whether the 64 bit version of shdocvw.dll was
in some way incompatible with the 32 bit excel. I have tried to
browse to the 32 bit version in Tools references but Vista just
ignores the new path.