MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!


Posted by Ivan Moala on March 28, 2000 8:28 PM


Try Application.enableevents=False
AND @ the end of the routine;
Turn the events back on via
Application.EnableEvents=true

OR
Try

Application.cutcopymode = False
after your paste routine


Ivan