Macro creation in excel

i want to create a macro that if no file is open in excel window then my macro will open any specific file and if any another file is open then that macro first close that open file and after that ope that specific file.
please mention in detail 'how to code in VBA'
Asked May 29, 2013

TIP: If it's not your answer to this question, please click "Leave a Comment" button under the question to communicate with the question owner.