Copying a Worksheet from an AddIn into an empty Workbook

  • Thread starter Thread starter =?ISO-8859-1?Q?Manuel_J=F6rges?=
  • Start date Start date
?

=?ISO-8859-1?Q?Manuel_J=F6rges?=

Hi,

I have a Worksheet in an AddIn. I want to copy this Sheet into a new,
empty Workbook.
I do this with the following Code:
Application.ThisWorkbook.Worksheets("Sheet1").Copy _
Before := ActiveWorkbook.Sheets("Sheet3")

The Problem is, that all Links in the new Workbook are changed from
='Sheet3!B17' to ='[AddIn.xla]Sheet3!B17'
Is there any possibility to prevent Excel to convert the Links?

Any Help will be gladly appreciate,

Manuel
 
After you copy the sheet use the ChangeLink method to fix the links.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tom Ogilvy code 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Copy a Sheet to an AddIn 2
SHEE1. Duplicate all sheets, making 2 copies of ea. / 2. Add " E"and " F" to end of tab name. / 3. 3
Disable row delete in a worksheet (not all worksheets in theworkbook) 3
VBA copy 'corrupts' font selection (XL2003) 2
Macro to cycle through worksheets 1
Copy paste a range from one Workbook to another 2

Back
Top