Microsoft Excel Popup Box automatically having it select yes

[zoog25]

Hello All,

Here is my situation. I have a program that I'm working on that transfers sheets from one workbook to another. Now every time it runs I get a popup message asking the following:
A formula or sheet you want to move or copay contains the name "TBDeveloper", which already exists on the destination worksheet. Do you want to use this version of the name?
-To use the name as defined in the destination sheet, click Yes.
-To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box.

Now the thing is that i don't want to message box to popup because the answer will always be "Yes". How do i prevent / have the program automatically answer yes to this question.

 

[NdNoviceHlp]

Hi zoog25. Trial moving the sheet using a collection. Something like this...

Dim FSO As Object, FilDir As Object, ShtCollect As Collection
Set FSO = CreateObject("Scripting.FilesystemObject")
'***adjust file path to suit
Set FilDir = FSO.getfile("C:\yourfoldername\filename.xlsm")
Application.DisplayAlerts = False
Workbooks.Open Filename:=FilDir
'load sheet in collection
Set ShtCollect = New Collection
ShtCollect.Add Workbooks(FilDir.Name).Sheets("Sheet1")
ShtCollect(1).Copy ThisWorkbook.Sheets(1)

Adjust the file path and sheet name to suit. HTH. Dave

 

[zoog25]

Thanks for the suggestion NdNoviceHlp.