I created a drop down list in three cells for date, month and year using data validation.
But I need these cells to display by default DD,MM,YYYY.
what's the way to do it.
thanks in advance
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...
I am trying to create an application where user can upload a file say .pdf and delete the same.
"how to change the attachment name in name bar so that I can refer it in my code."
At present the counter changes every time I attach a file for eg. I insert a pdf xyz it gives it name "object 5"...