I am trying to write a macro to save workbook in different location using the
ip address

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/

thank you very much

I was asking how it can be done but i think that i was able to figure it out
by using the code below
ActiveWorkbook.SaveAs Filename:="\\nnn.nnn.n.nn\shares\make\make1.csv",
FileFormat:=xlCSV, _
CreateBackup:=False

"T Lavedas" wrote:

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/