I dropped down to the C:\ prompt, then negotiated to the Content.MSO folder (since I couldn't find it in The Temporary Internet Files folder!) - but the error file that it referred to existed, but was blank.
Initially it said the file was corrupt - Which apparently if save as from email , you can right click And properties on it, and uncheck unlock property - that will get it past the corrupt message. Then it kept giving me XML errors in the <table> node - which after looking and looking finally jumped Out at me - it's wasn't a corrupt XML , it was invalid based on the schema - I had type that was "numeric" But the data was alpha numeric. Funny, once I fixed the XML to be valid, I no longer had to unlock it and could open it from the email Without getting the file corrupt error. So, I guess it scans the XML, if it's invalid, it throws the corrupt error unless the file is set for Unlock status. Uuugh....Why can't it just say data type mismatch found in XML data????? I think when I first created my routine, it was using Excel 2010 - which might not have been so Strict on the XML being invalid for that reason, and it worked. I guess I was taking advantage Of it's good naturedness - and Excel 2013 was just being a hardass.. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, March 24, 2014 3:05 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SpreadsheetML and Excel2013 George, if you're seeing the "Problems During Load dialog", the error might refer to the Content.MSO folder: C:\Users\username\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.MSO (on older systems that might be c:\WinTemp\Temporary Internet Files\Temporary Internet Files\Content.MSO) From the NebulaXLite Developer Guide page 49: "The Content.MSO directory is hidden.To get to the file, use Windows Explorer to get to the Temporary Internet Files folder, then in the address bar manually type “Content.MSO”.A list of files should display.(All files except the most recent can be deleted.)" XML files from v2003 "should" certainly be compatible with v2013. However, there are at least two kinds of XML out there. There is the SpreadsheetML and then there is a newer Open format which has been in transition over the years. It's possible though unlikely that v2013 has some detail "fixed" that an older version of Excel (or related tools) embedded into your documents. Without more information I couldn't make any other guesses. [ad] Relevant to MV/U2, NebulaXLite generates full Excel workbooks with rich sheets all from BASIC: http://Nebula-RnD.com/products/xlite.htm HTH Tony Gravagno, Nebula Research and Development http://Nebula-RnD.com/blog http://Twitter.com/TonyGravagno http://www.LinkedIn.com/in/TonyGravagno Visit http://PickWiki.com! Contribute! https://bitbucket.org/foss4mv _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
