Button for Query Table Data

I would like to create a button in excel that will basically run Query Table Data from the sforce connector toolbar. I tried to record a macro, but the record does not pick up anything from the sforce menu. I also looked at the VB editor, but everything in there related to the connector is password protected.