Correct the formula mentioned

Hi,


I have a VBA macro which exports the xml mentioned with xml schema . I want to export the xml with date mentioned in the excel sheet at cell D37 . Have written a macro to export with date . But macro is giving error


Here is the macro code:

Sub EXPORTLOG()
'
' EXPORTLOG Macro
'

ActiveWorkbook.SaveAsXMLData fileName:="C:\FILES\FILE WCM " & Range("D37").value .FormatConditions(Date, "yyyymmdd") & ".xml", Map:=ActiveWorkbook.
    XmlMaps ("LOG SCHEMA")
'
End Sub

Thanks in advance,
Mayur

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.