Clipboard

[Randy]

When using macros to retreive data from other spreadsheets (along with
copy and paste) and when closing the spreadsheet a dialog box appears
asking if you want to save the the information to the clipboard which
stops the macro until you answer the dialog box. Is there a way to
close the dialog box and not save the information on the clipboard in
the macro instead of having to answer.

 

[Guest]

Just an idea but I worked round that one by saving data in an array (i.e. using
myArray = myRange.value etc) rather than using copy and paste.
The only problem is that cell formats wont be saved.

Regards
Noel

 

[Tom Ogilvy]

after copying do

application.CutCopy = False

 

[Chip Pearson]

You can clear the clipboard with the follow code:

Application.CutCopyMode = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Tom Ogilvy]

Dang, typo
Application.CutCopyMode = False