Okay, Chris helped me figure out how to get the macro to work. I had a bad reference in vba. When I went to Tools > References, at the top of the list there appeared to be the references I needed:
Autodesk Civil Engineering Pipe 6.0 Object Library
Autodesk Civil Engineering UI Pipe 6.0 Object Library
Apparently these references were bad even though C3D 2009 users need to reference 6.0. Chris had me uncheck these anyways and recheck them below. Now it works well. If anyone was having the same problem as I was I hope this helps.
THANKS CHRIS!!! "You must spread Reputation around before giving it to chris805_1996 again."