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.