Hi,

It is 2003.

Thanks,
David

"Gary Keramidas" wrote:

you don't say which version of excel you're using. in a month or 2 there is
going to be another version released, 2010. we really need to know which os
and which version of excel people are using to give more accurate answers.

try turning uac off and see if that may be causing it.

--


Gary Keramidas
Excel 2003


"David" wrote in message
...
Hi BillyBob,

It is not the code, it works in another environment, Windows XP, but it
fails in Vista.
But it fails at the last line he
Sub SP500AdvDecl()
Range("A1").Select
ActiveCell.Columns("A:F").EntireColumn.Select
Selection.Insert Shift:=xlToRight
ActiveCell.Select
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://finance.yahoo.com/q/cp?s=%5EGSPC",
Destination:=Range("A1"))
.WebSelectionType = xlSpecifiedTables
.WebTables = "12"
.Refresh BackgroundQuery:=False
End With

It will not do this:
.Refresh BackgroundQuery:=False

Thanks,
David

"BillyBob" wrote:

"David" wrote in message
...
Hi Group,

I have a macro that runs in Windows XP just fine. When I take it over
to
Vista it fails. It fails when it tried to access during a web query. I
did
not see an option to Run as administrator, right clicking the Excel
Icon.

Appreciate any insights.

Thanks,
David

David,

No one can help you with your macro if you don't post your code.

BB


.