Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and Excel web query not accessing the Web
I have a web query in VBA that is not working although it works in other
computers. The reason is that it does not access the Internet. The same happens if I don't use VBA. After the usual Data/Import External Data/New Web Query the window starts in www.google.com and displays "Action Canceled. Internet Explorer was unable to link to the Web page you requested. The page might be temporarily unavailable." If I enter http://moneycentral.msn.com/detail/s...ote?Symbol=aig or http://moneycentral.msn.com/investor...asp?SYMBOL=IBM I receive a nasty "The page cannot be displayed. The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settinngs." However, the same query works in IE. Needless to say, I tried with other sites, and the result is the same. I'm using Windows XP, Excel 2003. My computer is part of a LAN, inside a SBC Yahoo firewall. I also disabled both the Windows and the SBC Yahoo firewalls and the results are the same: cannot connect. Any suggestion? Do I have to change any settings? Any Office Control to download or Office Web Components missing? How to add them? I looked for the requirements/options/settings to make Web Query run in Excel 2003 but couldn't find them on the Microsoft website (or anywhere else). Thanks guys, CW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing Excel pages using VB | Excel Discussion (Misc queries) | |||
Accessing Excel from VB | Excel Programming | |||
Accessing MS Project from Excel | Excel Programming | |||
Accessing Word from Excel | Excel Programming | |||
How to stop Excel from accessing the net | Excel Programming |