What I show below is the code I am using to save a copied and exported
workshet. What I want it to do is to send the email after the new workbook is
saved.

any help will be much obliged. I tried Ron deBruin's site and I am not
profficient enough to understand what may be going wrong.

many thanks in advance!!!!!!!
Alex

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+S
'
Sheets("ACTUAL Q").Select
Sheets("ACTUAL Q").Copy
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Call finish
End Sub
Sub finish()
Dim sBase As String
Dim sFile As String
sBase = Range("a28").Value
sFile = "c:\PROYECTO FA\" & sBase & ".xls"
ActiveWorkbook.SaveAs sFile
ActiveWorkbook.SendMail "
ActiveWorkbook.Close
End Sub