Vista

  • Thread starter Thread starter David
  • Start date Start date
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
 
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
Click to expand...

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




.
Click to expand...
 
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




.
Click to expand...
 
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
 
Back
Top