Hi everyone
I have a macro that I use for work and I create XML files from the data in the Excel file. The first column of the worksheet is named "modifier" and the value in this column may be "create" "delete" or "modify". I am currently writing in the same file indifferently from which is the modifier. What I want to do is create three different files and write them in function of the modifier.
So if the modifier is "create" write to Create.xml, if the modifier is "delete" write to Delete.xml and if the modifier is "modify" write to Modify.xml.
Thank you in advance!
I have a macro that I use for work and I create XML files from the data in the Excel file. The first column of the worksheet is named "modifier" and the value in this column may be "create" "delete" or "modify". I am currently writing in the same file indifferently from which is the modifier. What I want to do is create three different files and write them in function of the modifier.
So if the modifier is "create" write to Create.xml, if the modifier is "delete" write to Delete.xml and if the modifier is "modify" write to Modify.xml.
Thank you in advance!
