Closing a WorkBook

  • I have the following code that will open a txt file into a new workbook and then copy that workbooks cells into the workbook that i'm running. When i close the new workbook i get the question 'there is a large amount information on the clipboard, do you want to be able to paste it later? "YES", "NO" or "CANCEL".

    how can i get VB to answer 'yes' to that question automatically?
    or is there another way to close that workbook and after i have pasted the information?

    at the moment i have the workbook.close line commented out.

    Thank you
    Brian G.

    [SIZE="6"][FONT="Comic Sans MS"]Brain G.[/FONT][/SIZE] :loopain:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!