Nope..there is only one WCAddin.xla opened...the WCAddin.xls is not
opened..and I changed the code to reference WCaddin.xla.

It's copies the worksheets over just file.. It gets the error message when
it gets to this part of the code:
.Range("A1").Formula = .Range("A1").Value




"Bob Phillips" wrote in message
...
Surely, this is because there is already a file of that name open to
Excel,
so you can't have two.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KimberlyC" wrote in message
...
Hi,
I'm using the following code to add 4 worksheets from another worksheet
to
the active workbook.
It works great..unitl I change the Workbook name to the addin file name
of
"WCAddin.xla"...which is how I need to run that file.
I get a Run Time Error --Application- defined or object defined error
message.
Is this due to me changing the workbook file name to xla vs xls?
If yes.. how would I rewrite the code to work with the addin file
instead?


Public Sub AddWStoWCTemplate()

Workbooks("WCAddin.xls").Sheets(Array("Summary", "Adjustments",
"Details",
"Calculations")).Copy After:=ActiveWorkbook.Worksheets(Worksheets.Count)

With ActiveWorkbook
For i = .Worksheets.Count To .Worksheets.Count - 3 Step -1
With Worksheets(i)
.Range("A1").Formula = .Range("A1").Value
.Range("A2").Formula = .Range("A2").Value
.Range("A3").Formula = .Range("A3").Value
End With
Next
End With

End Sub