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" 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

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

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

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


.

Hi,

What is "uac"?

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


.

What is "uac"?

UAC = User Account Control. It is the Windows "features" new in Vista
that throw up a dialog box whenever you do almost anything asking "Are
your sure?".

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com




On Mon, 29 Mar 2010 07:03:02 -0700, David
wrote:

Hi,

What is "uac"?

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


.