hello

The code below exports a single instance of "myfile.xml" from book1.xls to a sharepoint server. Can anybody tell me how to generate multiple .xml files based on a variable or named range that the user accepts (eg from a named cell or drop down list)..

example:
user accepts company1 from dropdown and macro generates "myfile1.xml"
user accepts company2 from dropdown and macro generates "myfile2.xml"
user accepts company3 from dropdown and macro generates "myfile3.xml"


Sub ExportXML()
ActiveWorkbook.XmlMaps("XMLMap").Export ("http://mysharepoint.com/mydocuments/myfile.xml",True)           
End Sub
thanks
Conor