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