Convert to Values Only

I currently have a worksheet that uses a combination of web queries and normal formulas to fill in all the data. However, I need to distribute this worksheet to clients without all the web queries and formulas...just the values. This will be done fairly regularly, so manually using the Copy and Paste Special feature will not be very pratical. Is there a nice way to automate this?

Automating Paste Special is usually easy. Can you describe more fully what you need to do?

If the used range is not too large you can also get rid of the formulas this way...
[VBA]
Option Explicit

Sub ValuesOnly()
With ActiveSheet.UsedRange
.Value = .Value
End With
End Sub
[/VBA]