Excel Web Query with Password

I have a web query set up that pulls data from the following website: http://www.crmz.com the issue is you must long in through a web query in order to run the macro.

I would like to automate this longin process by putting my username in Cell A1 and password in cell A2.

You must long in at this address http://www.crmz.com

Does anyone know the VBA code to do this?

Have a read through this: http://www.excelforum.com/excel-prog...matically.html

Very useful. I had been searching for a thread like this all morning.