How to automatically pass log on credentials in an Excel report?

I guess I get to answer my own question.  More points for me!! 

After much searching and trial and error I ran across the solution here: http://stackoverflow.com/questions/22149169/how-to-pass-authentication-credentials-in-vba

Place the following code in the ThisWorkbook section in the VBAProject in Excel.  Change to point to your server and also use a valid username and password.

Private Sub Workbook_Open()

With CreateObject("Microsoft.XMLHTTP")
  .Open "GET", "https://your.windchill.server.com/Windchill/app", False, "username", "password"
  .Send
End With

ActiveWorkbook.RefreshAll

End Sub

Note that the username and password will be stored in cleartext in the VBS project.  To mitigate this  create or use an account with read only privileges.