Programatically copy worksheet via VBA in Excel

Hi,
I need to programatically copy a worksheet to a new workbook via VBA in Excel97 without any of the links back to the original workbook yet retain all data and formuli. I can already create the new workbook & copy the worksheets. I just need a way to Not have the Links in the new workbook. This is for a client who only wants to press a button. So, copy/paste or anyother non-coded method won’t work.

UPDATE: I just attempted to copy/paste special… well, that didn’t work either; something to do with invalid links – I don’t care!!! How stupid IS that – Just remove the frikkin links!!!

Thanx!

Dave