Vista

[David]

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

 

[BillyBob]

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

 

[David]

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 here:
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=^GSPC", Destination:=Range("A1"))
.WebSelectionType = xlSpecifiedTables
.WebTables = "12"
.Refresh BackgroundQuery:=False
End With

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

Thanks,
David

 

[Gary Keramidas]

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.

 

[David]

Hi,

It is 2003.

Thanks,
David

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]

Hi,

What is "uac"?

Thanks,
David

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




.

 

[Chip Pearson]

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