G
Guest
I am a self-taught user of VB for Excel and I've come along pretty well, but
I'm getting stuck on something that seems like it should be fairly simple to
do. I have two files: File1 contains a macro that performs various
functions on File2. When the File1 macro is finished, I want File1 to close
automatically WITHOUT prompting the user if they wish to save (this file
should never be saved by the user). What can I do to force Excel to close
the file without an option to save?
I'm getting stuck on something that seems like it should be fairly simple to
do. I have two files: File1 contains a macro that performs various
functions on File2. When the File1 macro is finished, I want File1 to close
automatically WITHOUT prompting the user if they wish to save (this file
should never be saved by the user). What can I do to force Excel to close
the file without an option to save?