BigSoccer.com Excel Table Builder Script

The updated BigSoccer has a new format for tables, and an require a lot of hand editing if you’re exporting data from excel, so I wrote a VBA script to automate this.

In order to run it you should make your selection of data you wish to export, then execute the script, it will then put the string needed to build the table into your clipboard to be posted at BigSoccer.

Download the VBA script here – BigSoccer.Com Excel Table Exporter - Version 1.0 .

In order for this to work you need to add a reference to “Microsoft Forms 2.0 Object Library” while in the Visual Basic Editor. This can usually be found in your c:\windows\System32 folder (may vary depending on Windows Version) as FM20.DLL.

If you think others would find this useful, please share!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>