Yes no drop down list and macros
 

I have an excel sheet that get imported into another workbook by way of a
macro.. This sheet contains two drop down lists.

When I run the macro I get an info box that pops up telling me:

"A formula or sheet you want to move or copy contains the 'YES_NO' which
already exists on the destination worksheet. Do you want to use this version
of the name?"

Can I add any code to the macro to always say yes to this and not see the
dialogue box ??


--
Thanks

Larry

Yes no drop down list and macros
 

Try

Sub Macro()
Application.DisplayAlerts = False

'your code here

Application.DisplayAlerts = True
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Larry Fitch" wrote:

I have an excel sheet that get imported into another workbook by way of a
macro.. This sheet contains two drop down lists.

When I run the macro I get an info box that pops up telling me:

"A formula or sheet you want to move or copy contains the 'YES_NO' which
already exists on the destination worksheet. Do you want to use this version
of the name?"

Can I add any code to the macro to always say yes to this and not see the
dialogue box ??


--
Thanks

Larry

Yes no drop down list and macros
 

I did not test but try
Application.DisplayAlerts=false
and then reset after the copy
Application.DisplayAlerts=true

I know this works to suppress the message when deleting sheets

--
If this helps, please remember to click yes.


"Larry Fitch" wrote:

I have an excel sheet that get imported into another workbook by way of a
macro.. This sheet contains two drop down lists.

When I run the macro I get an info box that pops up telling me:

"A formula or sheet you want to move or copy contains the 'YES_NO' which
already exists on the destination worksheet. Do you want to use this version
of the name?"

Can I add any code to the macro to always say yes to this and not see the
dialogue box ??


--
Thanks

Larry

Yes no drop down list and macros
 

THanks Jacob..

That worked great !!!

If I could ask another question... In the macro below I am able to source
the input sheet I am looking for and then I bascially do a copy and paste
into my workbook -

Sub Statistics_Input()
'
' Statistics_Input Macro
'
' Keyboard Shortcut: Ctrl+q
'
Application.DisplayAlerts = False
Application.ScreenUpdating = False
FOpen = Application.Dialogs(xlDialogOpen).Show(ThisWorkboo k.Path)
Range("C10:D88").Select
Selection.Copy
Windows(ThisWorkbook.Name).Activate
Sheets("Statistics").Select
Range("C10:D88").Select
ActiveSheet.Paste
Sheets("Selection Sheet").Select
Application.DisplayAlerts = True

End Sub

I cannot figure out how to close the source document after the cut and
paste..


--
Thanks

Larry


"Jacob Skaria" wrote:

Try

Sub Macro()
Application.DisplayAlerts = False

'your code here

Application.DisplayAlerts = True
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Larry Fitch" wrote:

I have an excel sheet that get imported into another workbook by way of a
macro.. This sheet contains two drop down lists.

When I run the macro I get an info box that pops up telling me:

"A formula or sheet you want to move or copy contains the 'YES_NO' which
already exists on the destination worksheet. Do you want to use this version
of the name?"

Can I add any code to the macro to always say yes to this and not see the
dialogue box ??


--
Thanks

Larry

Yes no drop down list and macros
 

Try the below

Dim wb As Workbook
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Application.Dialogs(xlDialogOpen).Show ThisWorkbook.Path
Set wb = ActiveWorkbook
wb.ActiveSheet.Range("C10:D88").Copy _
ThisWorkbook.Sheets("Statistics").Range("C10")
wb.Close False
Application.DisplayAlerts = True
Application.ScreenUpdating = True

If this post helps click Yes
---------------
Jacob Skaria


"Larry Fitch" wrote:

THanks Jacob..

That worked great !!!

If I could ask another question... In the macro below I am able to source
the input sheet I am looking for and then I bascially do a copy and paste
into my workbook -

Sub Statistics_Input()
'
' Statistics_Input Macro
'
' Keyboard Shortcut: Ctrl+q
'
Application.DisplayAlerts = False
Application.ScreenUpdating = False
FOpen = Application.Dialogs(xlDialogOpen).Show(ThisWorkboo k.Path)
Range("C10:D88").Select
Selection.Copy
Windows(ThisWorkbook.Name).Activate
Sheets("Statistics").Select
Range("C10:D88").Select
ActiveSheet.Paste
Sheets("Selection Sheet").Select
Application.DisplayAlerts = True

End Sub

I cannot figure out how to close the source document after the cut and
paste..


--
Thanks

Larry


"Jacob Skaria" wrote:

Try

Sub Macro()
Application.DisplayAlerts = False

'your code here

Application.DisplayAlerts = True
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Larry Fitch" wrote:

I have an excel sheet that get imported into another workbook by way of a
macro.. This sheet contains two drop down lists.

When I run the macro I get an info box that pops up telling me:

"A formula or sheet you want to move or copy contains the 'YES_NO' which
already exists on the destination worksheet. Do you want to use this version
of the name?"

Can I add any code to the macro to always say yes to this and not see the
dialogue box ??


--
Thanks

Larry