Yes No Auto-answer?
 

I open a .dbf file, copy its contents to a workbook and then close the .dbf
file all in a macro. Problem is the computer asks me if I want to save the
copy-paste data in the clipboard or free it up. I want to free it up but I
don't want the user of the macro to have a choice. Can I set up an
autoanswer or can make it not ask that question? Excel 2000.

Many thanks.

Yes No Auto-answer?
 

Application.CutCopyMode = False

will clear the clipboard

or
Application.DisplayAlerts = False
workbooks("MyDatabase.dbf").Close SaveChanges:=False
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy

"Joe Blow" wrote in message
news:DGFvc.659595$Ig.13619@pd7tw2no...
I open a .dbf file, copy its contents to a workbook and then close the
..dbf
file all in a macro. Problem is the computer asks me if I want to save the
copy-paste data in the clipboard or free it up. I want to free it up but I
don't want the user of the macro to have a choice. Can I set up an
autoanswer or can make it not ask that question? Excel 2000.

Many thanks.

Yes No Auto-answer?
 

Application.DisplayAlerts = False
workbooks("MyDatabase.dbf").Close SaveChanges:=False
Application.DisplayAlerts = True

Turning the displayalerts off will cause Excel to choose
the default choice, and the default for the large
clipboard message is to leave the information in the
clipboard so that it can be pasted later.

-----Original Message-----
Application.CutCopyMode = False

will clear the clipboard

or
Application.DisplayAlerts = False
workbooks("MyDatabase.dbf").Close SaveChanges:=False
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy

"Joe Blow" wrote in message
news:DGFvc.659595$Ig.13619@pd7tw2no...
I open a .dbf file, copy its contents to a workbook
and then close the
..dbf
file all in a macro. Problem is the computer asks me
if I want to save the
copy-paste data in the clipboard or free it up. I want
to free it up but I
don't want the user of the macro to have a choice. Can
I set up an
autoanswer or can make it not ask that question? Excel
2000.

Many thanks.




.

Yes No Auto-answer?
 

Thanks for the Additionan information.

If that is a problem, then

Application.CutCopyMode = False

would be appropriate

an alternative

Range("A1").Copy

would replace what is in the clipboard and would not raise the prompt.

--
Regards,
Tom Ogilvy


"Kris" wrote in message
...
Application.DisplayAlerts = False
workbooks("MyDatabase.dbf").Close SaveChanges:=False
Application.DisplayAlerts = True

Turning the displayalerts off will cause Excel to choose
the default choice, and the default for the large
clipboard message is to leave the information in the
clipboard so that it can be pasted later.

-----Original Message-----
Application.CutCopyMode = False

will clear the clipboard

or
Application.DisplayAlerts = False
workbooks("MyDatabase.dbf").Close SaveChanges:=False
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy

"Joe Blow" wrote in message
news:DGFvc.659595$Ig.13619@pd7tw2no...
I open a .dbf file, copy its contents to a workbook
and then close the
..dbf
file all in a macro. Problem is the computer asks me
if I want to save the
copy-paste data in the clipboard or free it up. I want
to free it up but I
don't want the user of the macro to have a choice. Can
I set up an
autoanswer or can make it not ask that question? Excel
2000.

Many thanks.




.