tag:blogger.com,1999:blog-2400890101678805672.post4016404334011086396..comments2022-04-10T14:16:52.330-04:00Comments on FranScribing: How to convert an Excel 2010 speadsheet to an XML fileFran Whttp://www.blogger.com/profile/03986922365623357071noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-2400890101678805672.post-49801610672752156232017-01-19T14:16:54.938-05:002017-01-19T14:16:54.938-05:00If you have tried to install XmlTools written by J...If you have tried to install XmlTools written by James Rivera in a 64 bit Excel install you receive an error because this add-in was written for 32 bit Excel installs.<br /><br />With a little trial and error I was able to update XmlTools.xla an Excel Add-in written by James Rivera to work with 64 bit Excel. I have tested this with Excel 2010.<br /><br />There were three modules that needed to be updated (CreateXmlFiles, GetCellXmlProps, and CreateXsdFiles). The code is to long to post in this forum but I have posted the information on MrExcel.com forums. Search for - SOLVED - Re: Extracting information from XML files using XmlTools Written by James Rivera. https://www.mrexcel.com/forum/excel-questions/750350-extracting-information-xml-files.html#post4733964<br /><br />Enjoy!!<br /><br />Regards,<br /><br />Joe CoyleJChttps://www.blogger.com/profile/09881867826192560657noreply@blogger.comtag:blogger.com,1999:blog-2400890101678805672.post-58229577080869503682015-08-20T09:47:58.616-04:002015-08-20T09:47:58.616-04:00i get run time error 1004. visible -not supported ...i get run time error 1004. visible -not supported ?????vijayakumarhttps://www.blogger.com/profile/07517041955308431661noreply@blogger.comtag:blogger.com,1999:blog-2400890101678805672.post-44497059690714888422015-06-23T10:35:44.079-04:002015-06-23T10:35:44.079-04:00Mine is a compiler error which ask me to update it...Mine is a compiler error which ask me to update it to 64bit using ptrSafe. How do I do this?PhillipOhttps://www.blogger.com/profile/09007907984417354865noreply@blogger.comtag:blogger.com,1999:blog-2400890101678805672.post-62383101208079166682015-04-20T11:00:34.708-04:002015-04-20T11:00:34.708-04:00Export option is graded out how do i exportExport option is graded out how do i exportAnonymoushttps://www.blogger.com/profile/02511788585639946978noreply@blogger.comtag:blogger.com,1999:blog-2400890101678805672.post-78224471720268119612014-11-14T04:00:48.446-05:002014-11-14T04:00:48.446-05:00The solutions : http://pixcels.nl/xmltools12/
Put ...The solutions : http://pixcels.nl/xmltools12/<br />Put XmlTools12.xla in \Office Samples\OfficeExcel2003XMLToolsAddin<br />like in the point 4. (4.In the Add-Ins dialog box, click Browse, locate the XmlTools.xla file, select it and then click OK. By default, this file is stored in the following folder:<br /> \Office Samples\OfficeExcel2003XMLToolsAddin)<br />Lucahttps://www.blogger.com/profile/18434122444087169428noreply@blogger.comtag:blogger.com,1999:blog-2400890101678805672.post-23440976313209270012014-10-31T05:47:18.638-04:002014-10-31T05:47:18.638-04:00Problem in using the tool:
This 1B6 Error Object ...Problem in using the tool: <br />This 1B6 Error Object does Not Support This Property or Method <br /><br />Load from origin, XML mapping, my xsd file; I run the mapping. <br />I select my entire affected table, tool, as add-in<br />XML Tools: Convert a Range to an XML List <br />I select the table, flags on - yes the first line contains the data, I have a message: <br />data will not be lost, but the list or xml mapped ranges will be converted to normal ranges and this can not be undone. Continue conversion? <br />Yes <br />and then I get the error 1B6: Property or method not supported by the object <br /><br />Any ideas, help, links, information, solution?<br />2 or 3 times I managed to get my xml file, and did not show this error. <br />I did the conversion on a regular basis with the tool and I exported all in XML. <br />Then close everything and reopen Excel and the problem, error 1B6 reoccurs ...Lucahttps://www.blogger.com/profile/18434122444087169428noreply@blogger.comtag:blogger.com,1999:blog-2400890101678805672.post-48025803167277041992014-10-30T11:08:03.228-04:002014-10-30T11:08:03.228-04:00Domanda: quando eseguo xml tools: convert range to...Domanda: quando eseguo xml tools: convert range to XML list <br />seleziono la tabella e <br />yes first row contains data,<br />ho l'errore 1b6 : proprietà o metodo non supportati dall'oggetto<br />Qualche aiuto?Lucahttps://www.blogger.com/profile/18434122444087169428noreply@blogger.comtag:blogger.com,1999:blog-2400890101678805672.post-9852918737628499042014-09-03T01:12:26.519-04:002014-09-03T01:12:26.519-04:00Thanks. This error message appears everytime when ...Thanks. This error message appears everytime when I open Excel. How to remove it forerver?Anonymoushttps://www.blogger.com/profile/01242965191802683487noreply@blogger.com