Let macro perform an action on 'excel close'
Posted by Remi on January 31, 2002 1:21 AM
hey, I`m building a macro which has to copie a few cell to another .xls file. This copying however, must take place when the first file is being closed.
How do I get this done? My approach would be: record a macro for the parts that are done within the first file. Then get into this macro and edit it. But it is virtually impossible to search for what I`m looking for via a keyword.
Hope someone can help me!