Hi Everyone,
I have a macro that export xml file into a a particular folder.
Is it possible to create a different filename everytime I export the file?
Or better maybe get the filename from a cell?
The one I have now is set to overwrite the existing filename.

Thanks!

Sub abc_test()
'
' abc_test Macro
'
' Keyboard Shortcut: Ctrl+q
'
ThisFile = Range("D3").Value
ActiveWorkbook.XmlMaps("abc_monitor").Export URL:= _
"O:\ABC TWO\REMOTE\xml\abc_test.xml ", _
overwrite:=True
End Sub