Hi all,

I got some problem about backup files. I set up procedure where everytime new data entered, and "save as" it with filename depends on TextBox1 like below:

Filename = T1.TextBox1.Text & "_V5.0.xls"
ActiveWorkbook.SaveAs Filename:="D:\Task 1\" & Filename, CreateBackup:=True

I got problem of putting backup files into seperate file from original spreadsheet. Everytime new data being saved, backup created. But, i need it to be in "Backup" file in "Task 1" folder.

Please help me....

Thanks