Re: "Do you want to replace the contents of the destination cells?"

G

Gord Dibben

Your Auto_Open code is obviously trying to paste something into filled cells or
similar operation like Text to Columns.

You can turn off the message and have it default to "Yes" but are you sure you
want the destination cells to be replaced?

Check your code to see what it is doing before adding more code to turn off the
message.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

Sometimes, this'll work:

Application.displayalerts = false
'your code that causes the alert to appear
application.displayalerts = true
 
D

Dave Peterson

Nope.

This doesn't even see the warning box--it just assumes that you don't want to be
bothered by the warning and that you know what you're doing.
 
D

Dave Peterson

I don't understand.

You said it works, but now it sounds like you still see the message.

Bob said:
Dave - Not sure why the "warning" appears, but the data I need
is there from the automation code in Access.

Thanks again - Bob
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Do you want to replace the destination cells? 5
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
How do I suppress the "Do you want to overwrite the destination cells" message 1
Do you want to replace the contents of 1
copying cell contents from one worksheet to another (re-sorted lis 2
Replace Contents of Destination Cells 2
Can the format of the destination cell be kept? 2
Excel VBA Paste Special - replace contents of destination cells 2

Top