A large amount of information on the clipboard

  • Thread starter Thread starter mdhingra01
  • Start date Start date
M

mdhingra01

Guest
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 amount of data. Is there a way to bypass this warning. I know if I manually cut and paste and then close the worksheet I am not prompted with this, but when using the macro it prompts me.

Please HELP!
 
I used the Application.DisplayAlerts = False in my maco and it worked.
 

Users who are viewing this thread

Back
Top Bottom