Hi harshaperla and rahul
To add ref of excel old means making project dependant.Eg by adding Excel olb 8.0 means ,prj ll execute on office 2000 only and not on 97.So instead of adding ref ,try to use CreateObject("Excel.Application") method , so that ur dependency ll b removed.
Now harshaperla u allow to open expected xls file using shellExcute API and allow the user to modify the file in excel app itself.And Befor closing the app through vb save that file.So i think its sumwht easy way to do this...
So if u require more clarification, plz let me no more details abt wht u want to do in ur application.
:-)

Dev-6