Copy and paste spread sheet

[broogle]

Is there anyway I can copy a spreadsheet from fileA.xls to fileB.xls
without creating the link (in formula) to fileA ?

I am using excel 2000.

Thanks

 

[Tom Ogilvy]

If you want to replace your formulas with the value they display
cells.Value = Cells.Value

if you have identical source data in the destination sheet and you change
the source
See changelink

ActiveWorkbook.ChangeLink "c:\excel\book1.xls", _
"c:\excel\book2.xls", xlExcelLinks

 

[broogle]

Thanks Tom!!