Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdhingra01
Posting Yak Master
179 Posts |
 Posted - 2004-09-16 : 10:04:30
|
| I am developing an application in MS Access and am using a macro to launch excel and run a macro in excel that cuts and copies data from a worksheet to another etc... When I run the macro I Excel prompts me if I am interested in saving the data on the clipboard as it s a large amoutn of data. Is there a way to bypass this. I know if I manually cut and paste and then close the worksheet where I cut the data from it doesn't prompt me, but when using the macro it does. Please HELP! |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-09-16 : 11:23:26
|
| Look into this.Application.DisplayAlerts = FalseWorkbooks("BOOK1.XLS").CloseApplication.DisplayAlerts = True |
 |
|
|
|
|
|
Do you want to save clipboard