Connect from Excel to SQL not working with id and password

I am trying to connect to sql server 2008 r2 from Excel 2010 (VBA). the process is for internal purposes only. I need to pass an id and password to connect to the db from excel. From everything that I have seen, if I specify Integrated Security=SSPI and specify an id and password, then it's supposed to use the id and password. However it does not. I have tried several variations and nothing seems to allow me to connect with the supplied id and password. Yes the id and passwords that I am using are valid. Any help is appreciated.