hi,
thank you very much.
yes it works.
excel_file = "\\Cctfil01\HRD-SpData\smd"
some thing else
if i want to save mytable or excel sheet at the same sever but i want the user
choise via myform ,somthing like getdir().put what you get at textbox and the path
can be autamiticly som thing as
excel_file = "\\Cctfil01\HRD-SpData\(thisform.text1.value)\smd"
any idea.
regards.