How to auto log-in into IP Address using vba

[slamet Harto]

Hi there,

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()
Blah---blah---blah--- then user can log in automatically without searching the IP address manually.

Appreciate your help on this case.
Many Thanks in advance.
Slamet

[Bob Phillips]

Cross-posted at ExcelVBA.