Hi

You must change it to read only
See this example
http://www.rondebruin.nl/sendmail.htm#Sheet


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Marino13 " wrote in message ...
When I run this code;

Sub Newe()
ActiveSheet.Copy
Set wb = ActiveWorkbook
With wb
SaveAs ("The File.xls")
SendMail ", Subject:= _
"Your file"
Kill .FullName
Close False
End With
End Sub

I am getting an error message that says:

Run-Time error '75':
Path/File access error

The debugger highlights the Kill .FullName line of my code.
What's wrong with this?


---
Message posted from http://www.ExcelForum.com/