I have a macro that works perfect with the exception that
I have to manual answer a question box that stops the
macro. The question box asks "There is a large amt of
info on Clipboard.. Do you want to use - Yes-No-Cancel?
How do I set it to Yes each time?

Two, how do I ClearContents on the clipboard after
saving. I have tried using Application.CutCopyMode =
False, but it does not clear the clipboard.

Any help would be appreciated.