My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 How to turn off clipboard clear notice in macro?
|
|
 May 24 2007, 11:26 AM
Post
#1
|
|
|
UtterAccess Guru Posts: 768 From: St.Louis, MO, USA  |
I'm running an Excel Macro fro inside of an access module. Part of the Excel macro does a copy paste.
How can I stop the message box "You have a lot of data copied to the clipboard"..asking "do you want to save the data on the clipboard?" ? This keeps me from being able to save/close the spreadsheet in Access. I assume I'd have to add something to disable the warning in Excel, but docmd. setwarning=false, does not work as it does in Access. |
 |
 
|
|
May 24 2007, 02:58 PM
Post
#2
|
|
|
Remembered Posts: 5,055 From: Minneapolis, MN, USA |
Hello,
how about running the following in your code? xlApp.CutCopyMode = False Where xlApp is your Excel Application Object Variable. You may want to post your code, though, there might be a better way...? |
|
|
|
|
May 24 2007, 03:13 PM
Post
#3
|
|
|
UtterAccess Guru Posts: 768 From: St.Louis, MO, USA |
That appears to work. Never would have found that one!
Thanks |
|
|
|
|
May 24 2007, 03:24 PM
Post
#4
|
|
|
Remembered Posts: 5,055 From: Minneapolis, MN, USA |
You are welcome. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)
Your Macro recorder, in Excel, will capture this when you record a copy, paste and hit your Esc key (to clear the clipboard) while recording. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif) |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 23rd May 2013 - 12:37 AM |