Ignore password prompt when opening file

I have the following code:

Please Login or Register  to view this content.

This opens the workbook - but the workbook is on my company's intranet, and it asks me for a username and password. I can just hit the escape key, and the file will load just fine, but I cannot figure out a way to get VBA to "hit escape" during the loading phase.

I've also tried the following code without any luck - it seems as though the code does not finish the "Set FSC" line (as the popup pops up) so it can never execute the application.sendkeys code.

Please Login or Register  to view this content.

Any ideas?