I need your help on how to use auto log-in into IP address
10.245.45.52 through/using VBA.

The problem is when user open .xls file, they have to get into the
IP address, otherwise the user cannot save the entry result into
their share drive.

Usually, user have to look for that IP address manually using
START+RUN+IP address, then on prompt user and password, they also
have to enter those two questions.

However, if we can use this entry below:
Private Sub WOrkbook_Open()

then user can log in automatically without
searching the IP address manually.


Appreciate your help on this case.