TrippyTom
02-18-2014, 03:54 AM
Hi everyone,
This may sound naive, but I'm new to using xml in Excel. I want to make a macro that will create a contact list in PPT from Excel data. I was thinking of making an xml file, but do I need to go that far, or should I just use a normal Excel file instead? I understand the purpose of xml is to separate the data from structure (format).
Is there any advantage to using .xml? If so, is it easy to access the data from an xml file in vba? I am not asking anyone to provide a complete answer; just to point me in the right direction.
I have so far managed to write the xml map for the data's structure and import it into an Excel file. But now I'm asking myself, "what now?" :)
This may sound naive, but I'm new to using xml in Excel. I want to make a macro that will create a contact list in PPT from Excel data. I was thinking of making an xml file, but do I need to go that far, or should I just use a normal Excel file instead? I understand the purpose of xml is to separate the data from structure (format).
Is there any advantage to using .xml? If so, is it easy to access the data from an xml file in vba? I am not asking anyone to provide a complete answer; just to point me in the right direction.
I have so far managed to write the xml map for the data's structure and import it into an Excel file. But now I'm asking myself, "what now?" :)