Hi All,

Below code is to save the excel file in specified path.

--------------------------------------------------------------------------
Dim strExcelSave As String

strExcelSave = "\\WKS0010(some other machine with in th
network)\test\Working Folders\Test.xls"

m_objExcel.ActiveWorkbook.SaveAs (strExcelSave)

MsgBox ("Your Report has been saved in "
strExcelSave & " path")

--------------------------------------------------------------------------
iam able to save the file perfectlly.

but if i want to save the file(test.xls) in other domain.

how can i place the file in other machine in other domain with the i
address.

please help me on this regard.

Thanks&Regards,
Areddy.

--
aredd
-----------------------------------------------------------------------
areddy's Profile: http://www.excelforum.com/member.php...fo&userid=2820
View this thread: http://www.excelforum.com/showthread.php?threadid=48756