VBA code for Clipboard Save Yes/No ???
Posted by Roman Viskup on March 28, 2000 1:58 PM
I have a Excel macro that opens/copies data/closes from a large number of workbooks into a summary workbook. The whole process is automated, except the step where the MS window pops up asking if I want the save the contents of the clipboard. Does anyone know what the VBA code would be to automatically respond "no" to this window. I tried the command "Clipboard.Clear" but I think that's only valid for VB, not VBA.
Thanks in advance!