How to clear clipboard when using vbscript

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

r_fordjr@msn.com - 12 Oct 2006 21:31 GMT

Hello all,
I have avbscript that runs a excel macro, but when the macro runs it
gives the clipboard full error, so I have to click the NO button for
the macro to completely execute. Is there a way I can get around this ,
so that i can "fully" automate the process?

Thank you in advance.

Reply to this Message

Gord Dibben - 12 Oct 2006 22:03 GMT

Application.CutCopyMode = False

Gord Dibben MS Excel MVP

>Hello all,
>I have avbscript that runs a excel macro, but when the macro runs it
[quoted text clipped - 3 lines]
>
>Thank you in advance.

Reply to this Message

Nick Hodge - 12 Oct 2006 22:22 GMT

Can you 'empty' the clipboard in your macro by copying an empty cell?

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
www.nickhodge.co.uk

> Hello all,
> I have avbscript that runs a excel macro, but when the macro runs it
[quoted text clipped - 3 lines]
>
> Thank you in advance.

Reply to this Message