Answering an Excel generated msg box Yes
 

Hi there,

I have a macro that opens multiple files (individually), copies and
pastes info into and then closes files.

Problem is when Im copying the info across I get the Excel generated
message that says "A formulae or sheet that you want to move or copy
contains the name "x" which already exists on the destination worksheet.
Do you want to use this version of the name?.. etc" Then you have the
yes no option.

I want, for the message box to automatically choose the YES option. (ie
so that the user doesnt have to click yes..)



Any ideas....?

Would it be easeier if I first copied to just another sheet in the same
book?

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***

Answering an Excel generated msg box Yes
 

Precede the code with

Application.DisplayAlerts = False

and reset afterwards

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Darin Kramer" wrote in message
...
Hi there,

I have a macro that opens multiple files (individually), copies and
pastes info into and then closes files.

Problem is when Im copying the info across I get the Excel generated
message that says "A formulae or sheet that you want to move or copy
contains the name "x" which already exists on the destination worksheet.
Do you want to use this version of the name?.. etc" Then you have the
yes no option.

I want, for the message box to automatically choose the YES option. (ie
so that the user doesnt have to click yes..)



Any ideas....?

Would it be easeier if I first copied to just another sheet in the same
book?

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***

Answering an Excel generated msg box Yes
 

Awesome Thanks!

*** Sent via Developersdex http://www.developersdex.com ***