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"


Please Login or Register  to view this content.
thanks
Conor