I want to place excel file in some other domain.
 

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

I want to place excel file in some other domain.
 

that is right!!!

instead of taking a String Variable you can also put the path directly in
saveas


m_objExcel.ActiveWorkbook.SaveAs
("\\WKstation\path\Text.xls")


Regards,
Ankit



"areddy" wrote in
message ...

Hi All,

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

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

strExcelSave = "\\WKS0010(some other machine with in the
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 ip
address.

please help me on this regard.

Thanks&Regards,
Areddy..


--
areddy
------------------------------------------------------------------------
areddy's Profile:
http://www.excelforum.com/member.php...o&userid=28204
View this thread: http://www.excelforum.com/showthread...hreadid=487560