I did this install myself also. The VSS wire on the NA auto trans is on the ECU. Of the three plugs, it's the one on the bottom so you will have to remove all three. Cut into the sheathing to reveal all the various wires and it's the solid yellow wire you want to tap. Good luck. It's pretty easy.
__________________
2007 Mean NA Solstice/UpShield/Lil' Chromies/Rear Debadged/Pioneer Avic-D3 Nav/DVD/Infinity Kappa component set/Coming soon: Amp and sub/Fujita CAI