VBA Fifth Dimension: Sport websites access

Excel VBA can copy data from web sites to spreadsheets with a few lines of code. This techniques have many applications. Just change the URL statement to copy any web site without parameters or special characters.

When Excel copies numbers separated by hyphens it changes the field and the format of the field to designate a date field. The QueryTables opiton ".WebDisableDateRecognition = True" enables numbers separated by hyphens to be copied without change.

The QueryTables opiton ".BackgroundQuery = False" will have the query refreshed when this block of code is run. It will wait until the query is done executing before continuing onto the rest of the code.

If you have any questions or you wish to comment, please e-mail me: tanesta@sas-tips.com

Purchasing the VBA Fifth Dimension macro code

This web site will constantly change to better equip VBA users with my techniques. Come back again to find something new and interesting.

More about this site and Thomas Anesta