Vista

D

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
 
B

BillyBob

David said:
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
 
D

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
 
G

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.
 
D

David

Hi,

It is 2003.

Thanks,
David

Gary Keramidas said:
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




.
 
D

David

Hi,

What is "uac"?

Thanks,
David

Gary Keramidas said:
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




.
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top