This one stumps me...

i have a filezilla FTP server on my desktop. I am using it to store some files remotely from my laptop. I had a method that worked perfect to access/save the files using the SERVER NAME. when i then tried to do the same using the IP ADDRESS it breaks.

This line of code works perfect:
FileToOpen2 = "ftp://anonymous@[SERVERNAME]/Tool_Database.xlsx"
    Application.Workbooks.Open (FileToOpen2), ReadOnly:=True
this does not:
FileToOpen2 = "ftp://anonymous@X.XXX.XXX.XXX/Tool_Database.xlsx"
    Application.Workbooks.Open (FileToOpen2), ReadOnly:=True
any ideas of what i can do here? i might be able to stay with the server name, i am curious as much as anything.