The macro prompts the user to open a workbook, the it copy's that data, but I want to close the workbook and save the clipboard to paste later. What is the code to save the clipboard.

Thanks,