I’ve had a couple of people contact me about how to use the BigSoccer.com table exporter macro for Excel, so I wrote up some instructions on how to do it as best as I could.
I’m using Office 2010 and haven’t verified/tried these instructions on any other versions, but i’d imagine they are similar.
Ok first you’ll have to save your excel spread sheet as a macro enabled (should be a *.xlsm), otherwise you can’t do anything with it.
Then you need to turn on the developer tool bar, right click on the ribbon and select Customize The Ribbon, there should be a “Developer” option on the right, enable that and click ok.
Now go to the Developer ribbon and click on Visual Basic.
Copy and past the VB code that you downloaded into your “ThisWorkbook” section.
Then you’ll need to add a reference to the MSforms (FM20.dll).
Do this click “Tools” then References. Click Browse and go to your windows\system32 folder and select “Fm20.dll”.
Now you should be able to run the VBA code (hit the play button when in the function).
This will take any data you have selected in the actual spread sheet, format it for BigSoccer and put it in your clip board to paste here.
For an external link describing the above with screen shots try this site.
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.
Thanks to user Brian Baker, support has been added to allow the media keys on certain keyboards to control playing/pausing of tracks, as well as skipping/moving to the next track.
Start your download of Pandora One Auto Hot Key Keyboard Short Cut Scripts - Version 1.4 now or visit the Pandora One Keyboard Short Cut Page.
As per a request by user Max Baryhnikov, i’ve added the ability to override the default location of the configuration file.
This can be done with the following command line option
Command Line Arguments
||The full path to the configuration file to load
More details can be found here Lock and Load page. Download Lock and Load - Version 1.2.1 now!
Recently one of the forums I frequent, Big Soccer recently upgrade their software and the new style is a bit controversial. So instead of just complaining, I used the really nice plugin (for Chrome and Firefox) called stylish which lets you apply custom CSS style sheets for sites.
Here is my result, makes things a little cleaner and easier to read. Let me know if you like it and find it useful, or if you’d like to see something added/changed.
Thanks to a tip by ErcDaMerc I’ve added an updated version of the script which should now work more consistently when minimizing, then restoring the Pandora One window.
Start your download of Pandora One Auto Hot Key Keyboard Short Cut Scripts - Version 1.3.1 now or visit the Pandora One Keyboard Short Cut Page.
I developed the app as a way to automatically pause the Pandora One application whenever I locked my machine, and it works very well for this task.
I’m curious to hear what people are using Lock and Load for, so if you use the tool and enjoy it please leave a comment/link to what you’re using it for.
Thanks to a request by user ErcDaMerc i’ve added the ability to both minimize and activate (restore) the Pandora One window with a hot key.
Ctrl-Win-Alt-O will restore the minimized Pandora One window and give it focus.
Ctrl-Win-Alt-M will minimize the Pandora One window.
Start your download of Pandora One Auto Hot Key Keyboard Short Cut Scripts - Version 1.3 now or visit the Pandora One Keyboard Short Cut Page.
As per a request by user Matt, i’ve added a new configuration option –
Which if set to false will stop a notification icon from being created, for cases where direction end user interaction with Lock and Load isn’t desired.
More details can be found here Lock and Load page. Download Lock and Load - Version 1.2 now!
Thanks to a tip form Funk, who noticed that the Keyboard Short Cut script for Pandora One would send commands to any active Adobe AIR window, now just Pandora One.
This issue has been rectified, please download Pandora One Auto Hot Key Keyboard Short Cut Scripts - Version 1.2.1 or visit the Pandora One Keyboard Short Cut Page.