tkaplan
11-23-2005, 08:34 AM
I have a whole big macro that i wrote that part of it copies cells and pastes to another workbook, then it closes the first workbook.
when i run the macro, the message comes up asking me if i want to save the data in the clipboard before it closes the file.
How can i eliminate that? i do not want the data saved to the clipboard and i dont want the user having that option.
Also, when i do a save as using a macro, it asks me if i want to replace the existing file. I want this to always be yes as well, without asking the user.
Any suggestions of what line of code i can add to take care of this?
when i run the macro, the message comes up asking me if i want to save the data in the clipboard before it closes the file.
How can i eliminate that? i do not want the data saved to the clipboard and i dont want the user having that option.
Also, when i do a save as using a macro, it asks me if i want to replace the existing file. I want this to always be yes as well, without asking the user.
Any suggestions of what line of code i can add to take care of this?