I want to use VBA to login to a website and then retrieve data to worksheet using web query. Everything works fine on one of my computer with Excel 2007 and WinXP. However, on my Excel 2010 and win7 computer, VBA works fine but web query didn't know that I had already login on IE, therefore retrieving wrong data. The web query works fine after I login manually on Chrome using IE Tab addin.

Does anyone know what's wrong with my win7 computer setup? Thanks a lot.