copying worksheet to another workbook with a macro more than once

's Computer Specifications

I want to copy a worksheet to another workbook and break the link on the
orginal worksheet. I recorded a macro. but I can only do it once.
How can I did it several times?

's Computer Specifications

Try something like:

Sub Macro1()
Windows("Book1").Activate
Sheets("rt").Copy Before:=Workbooks("Book2").Sheets(1)
Windows("Book1").Activate
Sheets("rt").Copy Before:=Workbooks("Book2").Sheets(1)
Windows("Book1").Activate
Sheets("rt").Copy Before:=Workbooks("Book2").Sheets(1)
Windows("Book1").Activate
Sheets("rt").Copy Before:=Workbooks("Book2").Sheets(1)
End Sub

--
Gary''s Student - gsnu200755

"RT" wrote:

> I want to copy a worksheet to another workbook and break the link on the
> orginal worksheet. I recorded a macro. but I can only do it once.
> How can I did it several times?

's Computer Specifications

Hi RF,

I used this recently, which I found in another posting:

With ActiveWorkbook
Links = .LinkSources(xlExcelLinks)
If Not IsEmpty(Links) Then
For i = 1 To UBound(Links)
.BreakLink Links(i), xlLinkTypeExcelLinks
Next i
End If
End With

"RT" wrote:

> I want to copy a worksheet to another workbook and break the link on the
> orginal worksheet. I recorded a macro. but I can only do it once.
> How can I did it several times?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro for Copying Worksheet to New Workbook	=?Utf-8?B?TUdD?=	Microsoft Excel Misc	10	17th Aug 2007 01:57 AM
Copying a worksheet into the same workbook	=?Utf-8?B?TWljaGFlbA==?=	Microsoft Excel New Users	9	6th Feb 2006 08:35 PM
Copying A Worksheet From Each Open Workbook to an new Workbook	=?Utf-8?B?Y2FybA==?=	Microsoft Excel Worksheet Functions	1	3rd Jan 2006 05:37 PM
Copying worksheet from workbook to another	=?Utf-8?B?TWFyayBKYWNrc29u?=	Microsoft Excel Worksheet Functions	0	14th Jan 2005 09:05 PM
Copying worksheet to another workbook	Haider Quazilbash	Microsoft Excel Programming	2	22nd Sep 2003 06:23 PM