Resolved Question: Help required in the VBA Project?

Any one can help me to overcome this problem pl.
I am using the following VBA code to save the Excel sheet in to a seperate file in the name of the
value in the cell.

Sub FileSave()
Dim Path As String
Dim FilNam As String
Dim FilNam2 As String
Path = "D:\TEMP\"
FilNam = Range("A7")
FilNam2 = Range("A16")
ActiveSheet.Copy
ActiveSheet.SaveAs Filename:=Path & FilNam & FilNam2 & ".xls"
ActiveWorkbook.Close
End Sub

In this i am using some link in that particular sheet with other sheets in the Same Workbook , So by using the above programe we can save that particular sheet as new file , but any changes in the old sheet which is already linked will leads to change in the Newly saved file, So my purpose of writing coding was gets useless.

Can anyone help to overcome this issue will be highly useful
Thanks and regards
S.Prabhakaran