Hi,
Pls find in the link :https://www.dropbox.com/s/6vr6v3nmw88aa0x/code.txt?dl=0
Pls find above link for the vba code that I am using.It works fine while using but the problem arises when I save and reopen the workbook.When I reopen the workbook it starts recovering and repairing the excel file and after that it whole structure of workbook gets changes.The error while looking in xml which is also enclosed in attachment could not able to understand.Kindly help me solving the issue.
Also,original workbook might be send if an email id is sent since it is private and confidential.
Pls find in the link :https://www.dropbox.com/s/6vr6v3nmw88aa0x/code.txt?dl=0
Pls find above link for the vba code that I am using.It works fine while using but the problem arises when I save and reopen the workbook.When I reopen the workbook it starts recovering and repairing the excel file and after that it whole structure of workbook gets changes.The error while looking in xml which is also enclosed in attachment could not able to understand.Kindly help me solving the issue.
Also,original workbook might be send if an email id is sent since it is private and confidential.