Macro vb to extract to Microsoft Word

[#1]

Hi everybody!

anyone know how to write a vb macro to extract a table in Microsoft Word's file?

I did it in excel but not in word...

sorry about my english...

thanks who will reply...

Alessandro

[Anonymous]

Alessandro,
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 not 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.
Sorry for the bad news

[rwunderlich]

Alessandro,

Please clarify. Which do you want to do?

1. Export(write) a QV Chart to MS Word.

2. Load (read) a table from MS Word into QV.

-Rob

[#4]

Hello Alessandro,

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...

regards Mark

[#5]

To Rob: the first one

To all: thanks so much for the replies!!!

Ale

[#6 · Accepted solution]

In that case, you can try this:

Sub ExporttoWord
 set obj = ActiveDocument.GetSheetObject("TB01")
 obj.ExportHTML "C:\test.doc"
end sub

regards Mark

[#7]

Hi Alessandro.

I know this past is a quite old, but I can propose you a software we developped which is called cilprint.

Cilprint allow your users to create an manage Word templates documents based on Qlikview dashboard object.

Without any technical knowledge !

A trial version is available at Normal 0 21 false false false FR X-NONE X-NONE MicrosoftInternetExplorer4 : http://bit.ly/i2eIhT

Feel free to test it and keep me posted.

With best regards,

Sébastien

cilprint@cilaos-conseil.com