saving using ip address

[maju]

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

 

[T Lavedas]

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/

 

[maju]

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