This seems pretty simple.  You should be able to record a macro that selects
the data and then opens a new file, pastes the data and saves to your c drive.

The VBA behind it would look something like this:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 11/21/2007 by Roger Converse
'
' Keyboard Shortcut: Ctrl+w
'
   Range(Selection, Selection.End(xlToRight)).Select
   Range(Selection, Selection.End(xlDown)).Select
   Selection.Copy
   Workbooks.Add
   ActiveSheet.Paste
   Application.CutCopyMode = False
   ActiveWorkbook.SaveAs Filename:= _
       "C:\temp\saves.csv", FileFormat:= _
       xlCSVMac, CreateBackup:=False
   Range("A1").Select
End Sub