how to attach xml to mail

[punkS]

i am creating xml file in excel using macros but the code asks user to save......


Filename = Application.GetSaveAsFilename( _

InitialFileName:="myrange.xml", _

fileFilter:="XML Files(*.xml), *.xml")


but i want to save it at default path and attach to mail....


*the dialog box to save file should not be shown to user*

 

[bobhc]

Good day punkS


If you use the search box top right you will get many examples or try this link


http://www.rondebruin.nl/notes.htm