sitewolf
Active Member
- Joined
- May 4, 2012
- Messages
- 304
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.
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.