Hi,

How do i get my marcos to automatically clear the clipboard when closing a
file. Currently, the macros close a csv file once the contents have been
copied into a central sheet. I am then faced with the question "There is a
large amount of data in the clipboard, would you like to keep it.........."

Once macro does this to 15 files and it is really annoying to have to keep
clicking 'No' when i run it.

Any help is much appreciated

Cheers

Greg

hi,
At the end of your macro put this

Application.cutcopymode = false

Regards
FSt1

"Greg Billinge" wrote:

Hi,

How do i get my marcos to automatically clear the clipboard when closing a
file. Currently, the macros close a csv file once the contents have been
copied into a central sheet. I am then faced with the question "There is a
large amount of data in the clipboard, would you like to keep it.........."

Once macro does this to 15 files and it is really annoying to have to keep
clicking 'No' when i run it.

Any help is much appreciated

Cheers

Greg

Greg,

You could also use:

application.displayalerts=false

before your processing starts. This will also suppress messages like "File
already exists - overwrite?"

You can turn the display on and off within a macro with =true/=false, but
the setting reverts to true when the macro stops running

Hope this helps

Pete




"Greg Billinge" wrote:

Hi,

How do i get my marcos to automatically clear the clipboard when closing a
file. Currently, the macros close a csv file once the contents have been
copied into a central sheet. I am then faced with the question "There is a
large amount of data in the clipboard, would you like to keep it.........."

Once macro does this to 15 files and it is really annoying to have to keep
clicking 'No' when i run it.

Any help is much appreciated

Cheers

Greg