Hi Dudes!

I wonder how I can send a site in an excel sheet with the usage of VBA. But only on site of an excel sheet. If I have a site where the users have to fill in data, only this site of the excel-sheet should be send to a recipient.

Sorry for my bad english! I hope you understand what I want to say!

:D

Jim

Hi Jim

I've made it by this way:
First copy activesheet to new workbook and save it (Temp.xls).
Send activeworkbook as an attachment to somebody.
Delete the temporary file.
Here's the code

Sub Send()
    Dim Filename As String

    ActiveSheet.Copy
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs "Temp.xls"
    Filename = ActiveWorkbook.FullName
    Application.DisplayAlerts = True
    ActiveWorkbook.SendMail "[email protected]", "Subject"
    ActiveWorkbook.Close False
    Kill Filename
End Sub



-vemaju