Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 01-17-2014, 11:56 AM
YounesB3 YounesB3 is offline VBA and web data Windows XP VBA and web data Office 2010 32bit
Advanced Beginner
VBA and web data
 
Join Date: Jul 2012
Posts: 37
YounesB3 is on a distinguished road
Default

Quote:
Originally Posted by BobBridges View Post
Yep, I get the same thing. I played around with the URL a while, in the program, and believe it or not, what appears to make it unhappy is the square brackets; my browser thinks they're valid, alright, but when I remove "[game]" from the URL then the VBA error goes away.

This may not be good news for you. Unless there's a way to persuade VBA that this is a valid URL, or a way to get the data from metacritic without the square brackets, you may have to rethink your solution. But the first thing I'd do is start asking around to see whether there's an Excel setting that'll tell it to be less stringent about valid URL characters. Maybe you'll be able to Google something about it. Failing that, maybe the folks at metacritic can offer you a workaround.

I might have googled it myself, but I gotta go soon; I have a meeting in a few hours.
Thanks for that indication..!

I've simply put the "[game]=1" portion in my L4 formula and it seems to work for now.


Now I need help for the next steps! :P Should I make another topic?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Match two sets of data and display specific data lolly150 Excel 1 05-14-2012 10:33 PM
Edit Data Source- Linking template charts to new data lbf PowerPoint 0 10-28-2011 12:19 PM
Powerpoint: adding data to trend lines w/o data labels HaiLe PowerPoint 0 04-11-2011 09:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft