saving using ip address

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

maju - 29 May 2008 19:35 GMT

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

Reply to this Message

T Lavedas - 29 May 2008 19:43 GMT

> 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/

Reply to this Message

maju - 29 May 2008 20:01 GMT

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

> > I am trying to write a macro to save workbook in different location using the
> > ip address
[quoted text clipped - 9 lines]
> ===========
> http://members.cox.net/tglbatch/wsh/

Reply to this Message