Editing a macro which automatically open and close after the macro runs

I spend hours trying to edit my macro which when opened it will run the macro and create a separate file and then closes by it self.

Thanks for this post to same my time.

http://www.excelforum.com/excel-new-users-basics/881031-cant-edit-macro-with-auto-open-and-auto-close.html

All you need to do is to 

1. Open the excel application 
2. Go to File
3. Go to Open
4. Pres on Shift Button
5. Then select the macro file
6. Go to view
7. Select the view macro to see the code

:)