How to avoid username/password dialog box when my app. opens .xls via Internet?

M

Marvin Hlavac

Hi all,

My XL application has a button that opens .xls file via the Internet:

Private Sub CommandButton2_Click()
Workbooks.Open Filename:="http://www.xxxxx.com/file.xls"
End Sub

When I click on the button I'm asked for user name & password. Is there a
way to put the user name and password into the above sub so users are not
asked for it? The file is not password protected, it is only because the
file is on the Internet.
 
Top