Am using different file name, so when am running the file, i need to change the file name from macro, so instead ed of go to edit->vb macro, If possible,in work only, if i enter the data, after that data will replace the code in particular line. If third person whats to run the code, just give the file name and use the short cut key to run the code.
So no need to go and modify the code.