On May 29, 2:35 pm, maju wrote:
I am trying to write a macro to save workbook in different location using the
ip address

And your question is?

You should be able to use the UNC form: "\\nnn.nnn.nnn.nnn\sharepoint
\folder\filename.xls"

Is that what you were after?

Tom Lavedas
===========
http://members.cox.net/tglbatch/wsh/