Copy Worksheet
 

I want to copy one worksheet to another open workbook with VBA.
I want the user to select any of the open workbooks to copy the worksheet to.
How can I call the dialog "Move or Copy Sheet..." from VBA?

Thanks for your help
reklamo

Copy Worksheet
 

Sub msheet()
Application.Dialogs(xlDialogWorkbookCopy).Show
End Sub

--
Gary''s Student - gsnu200857


"reklamo" wrote:

I want to copy one worksheet to another open workbook with VBA.
I want the user to select any of the open workbooks to copy the worksheet to.
How can I call the dialog "Move or Copy Sheet..." from VBA?

Thanks for your help
reklamo

Copy Worksheet
 

Thanks, it's working

Regards
reklamo


"Gary''s Student" wrote:

Sub msheet()
Application.Dialogs(xlDialogWorkbookCopy).Show
End Sub

--
Gary''s Student - gsnu200857


"reklamo" wrote:

I want to copy one worksheet to another open workbook with VBA.
I want the user to select any of the open workbooks to copy the worksheet to.
How can I call the dialog "Move or Copy Sheet..." from VBA?

Thanks for your help
reklamo

Copy Worksheet
 

Thanks for the feedback.
--
Gary''s Student - gsnu200857


"reklamo" wrote:

Thanks, it's working

Regards
reklamo


"Gary''s Student" wrote:

Sub msheet()
Application.Dialogs(xlDialogWorkbookCopy).Show
End Sub

--
Gary''s Student - gsnu200857


"reklamo" wrote:

I want to copy one worksheet to another open workbook with VBA.
I want the user to select any of the open workbooks to copy the worksheet to.
How can I call the dialog "Move or Copy Sheet..." from VBA?

Thanks for your help
reklamo