Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting rid of the Copy Paste Message?

Status
Not open for further replies.

jonx

Programmer
Sep 2, 2003
34
0
0
US
Hello, I am creating a program that uses Excel. What it does is it copies and pastes large amounts of data to other cells, and every time I run my program and exit, it asks me if I want to keep the data that I copied onto the clip board. Is there a way to get rid of this annoying message? I would like this message to automaitcally respond to this message by saying no, I don't want the data to remain on the clip board.

help?
 
Have you tried using the excel object VBA?(<-- I assume this is the way you are doing it)

Code:
Me.myExObj.Application.DisplayAlerts = False



Charles
Quality Assurance/Developer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top