topic Macro vb to extract to Microsoft Word in QlikView https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143628#M22814 <HTML><HEAD></HEAD><BODY><P>Alessandro,<BR />In October 2006, at the first Qonnection event, I attended a presentation named sometning like "How to extract data from virually anything". And, I asked a question - "What QV can <STRONG>not</STRONG> extract?" And the example of "can not" was exactly this - reading data from a table in MS Word. Not absolutely impossible, but definetely too complex to figure out the way around the MS Word formatting.<BR />Sorry for the bad news<IMG alt="Sad" src="http://community.qlik.com/emoticons/emotion-6.gif" /></P></BODY></HTML> Thu, 07 May 2009 23:57:32 GMT Anonymous 2009-05-07T23:57:32Z Macro vb to extract to Microsoft Word https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143627#M22813 <HTML><HEAD></HEAD><BODY><P>Hi everybody!</P><P>anyone know how to write a vb macro to extract a table in Microsoft Word's file?</P><P>I did it in excel but not in word...</P><P>sorry about my english...</P><P>thanks who will reply...</P><P>Alessandro</P><P></P></BODY></HTML> Thu, 07 May 2009 22:32:22 GMT https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143627#M22813 2009-05-07T22:32:22Z Macro vb to extract to Microsoft Word https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143628#M22814 <HTML><HEAD></HEAD><BODY><P>Alessandro,<BR />In October 2006, at the first Qonnection event, I attended a presentation named sometning like "How to extract data from virually anything". And, I asked a question - "What QV can <STRONG>not</STRONG> extract?" And the example of "can not" was exactly this - reading data from a table in MS Word. Not absolutely impossible, but definetely too complex to figure out the way around the MS Word formatting.<BR />Sorry for the bad news<IMG alt="Sad" src="http://community.qlik.com/emoticons/emotion-6.gif" /></P></BODY></HTML> Thu, 07 May 2009 23:57:32 GMT https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143628#M22814 Anonymous 2009-05-07T23:57:32Z Macro vb to extract to Microsoft Word https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143629#M22815 <HTML><HEAD></HEAD><BODY><P>Alessandro,</P><P>Please clarify. Which do you want to do?</P><P>1. Export(write) a QV Chart <STRONG>to</STRONG> MS Word.</P><P>2. Load (read) a table <STRONG>from</STRONG> MS Word into QV.</P><P>-Rob</P></BODY></HTML> Fri, 08 May 2009 00:17:04 GMT https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143629#M22815 rwunderlich 2009-05-08T00:17:04Z Macro vb to extract to Microsoft Word https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143630#M22816 <HTML><HEAD></HEAD><BODY><P>Hello Alessandro,</P><P>The easiest way is off course just copy-pasting the table from word into excel. Another way is to write an Excel-Vba aplication that automatically performs this task for you. From your QlikView macro you could just open this Excel sheet automatically so the vba application can 'import' the table from Word. And then you can simply import the table from Excel using the same QV macro. Just an idea...</P><P>regards Mark</P></BODY></HTML> Fri, 08 May 2009 01:33:37 GMT https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143630#M22816 2009-05-08T01:33:37Z Macro vb to extract to Microsoft Word https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143631#M22817 <HTML><HEAD></HEAD><BODY><P>To Rob: the first one</P><P>To all: thanks so much for the replies!!!</P><P>Ale</P></BODY></HTML> Fri, 08 May 2009 15:40:29 GMT https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143631#M22817 2009-05-08T15:40:29Z Macro vb to extract to Microsoft Word https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143632#M22818 <HTML><HEAD></HEAD><BODY><P>In that case, you can try this:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Sub ExporttoWord<BR /> set obj = ActiveDocument.GetSheetObject("TB01")<BR /> obj.ExportHTML "C:\test.doc"<BR />end sub<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>regards Mark</P></BODY></HTML> Fri, 08 May 2009 15:48:51 GMT https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143632#M22818 2009-05-08T15:48:51Z Macro vb to extract to Microsoft Word https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143633#M22819 <HTML><HEAD></HEAD><BODY><P>Hi Alessandro.</P><P>I know this past is a quite old, but I can propose you a software we developped which is called cilprint.</P><P>Cilprint allow your users to create an manage Word templates documents based on Qlikview dashboard object.</P><P>Without any technical knowledge !</P><P>A trial version is available at Normal 0 21 false false false FR X-NONE X-NONE MicrosoftInternetExplorer4 : <A href="http://bit.ly/i2eIhT">http://bit.ly/i2eIhT</A></P><P><BR />Feel free to test it and keep me posted.</P><P>With best regards,</P><P>Sébastien</P><P>cilprint@cilaos-conseil.com</P><P></P><P></P></BODY></HTML> Tue, 28 Dec 2010 11:21:58 GMT https://community.qlik.com/t5/QlikView/Macro-vb-to-extract-to-Microsoft-Word/m-p/143633#M22819 2010-12-28T11:21:58Z