I'm using Visio 2010 to do some early project planning (the brainstorming bit). I want to export the text with associated hierarchy so am using the export function. I select to export to but it is kicking out an XML file. header of the XML file is:
Workbook xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:bs="http://schemas.microsoft.com/visio/2003/brainstorming"> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"/
Workbook xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:bs="http://schemas.microsoft.com/visio/2003/brainstorming">
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"/
suggesting it is for Excel. How do I get it into excel?
How do I get it into excel
With a macro that strips out the text.
@NotThamesWater started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
I'm using Visio 2010 to do some early project planning (the brainstorming bit). I want to export the text with associated hierarchy so am using the export function. I select to export to but it is kicking out an XML file. header of the XML file is:
suggesting it is for Excel. How do I get it into excel?