Web query questions

[sitewolf]

I've used web queries for years, but just never got around to improving my methods. Usually I'm grabbing sports stats from various web sites and often it's just minor tweaks to a couple formulas to go from one season to the next. However, sometimes I'm grabbing ytd stats rather than box scores and that requires editing multiple urls. I'd like to do that more easily than using 'edit query', in part because so often I run into multiple script errors as I do that before I can even edit the url. I've never understood why there isn't an easier way to edit urls...maybe there is in newer versions? I'm still on 2007.

Is the answer for me to be using VBA to set up these queries? If so, what is the procedure to do that?
Or, if the answer is to break down and upgrade to Office 365, it's past due time.

 

[Rijnsent]

Hi sitewolf,
I would indeed go for the VBA route. I am not aware of an easier way in the newer versions of Excel (have 2013 here), they've hidden those features quite well :|. So I would start by changing one or two queries manually while recording that with the macro recorder and use that as a basis for an automated process. Next, you could take that bit of code to build a macro to do that job for you. A starter is e.g. Excel Macro Recorder - EASY Excel VBA
If you have some code, please feel free to post it here for feedback (in [CODE][/CODE] brackets).
Cheers,
Koen