VBA Server Name error

[roei61]

Hi to all the forum's memebers.

I have a vba code which establish connection to the TM1 and then runs some process.
My code is working well but there is one station that I'm trying to run the vba script in it and I'm having a connection error message.
When I changed the server name into the ip address it worked fine.
I thought that it might be relevent to the DNS definitions but when I tried to ping the server name in the cmd it was fine.
What may solve my problem?

Thanks to the helpers
Roei

[tomok]

I have a vba code

it would behoove you to read the request for assistance guidelines and then come back again with a revised request. Once I saw that snippet, and didn't see an example, I read no further.