I want to place excel file in some other domain.

[areddy]

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.

 

[Ankit Wadhawan]

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