ExportBiff

[gbovini]

Hi !

i've ver. 9.0 SR3

I would like to export in excel a table, and this istructions give error.

set obj = ActiveDocument.GetSheetObject("table name")

obj.ExportBiff("c:\Programmi\QlikView\Test.xls") or obj.Export "C:\Programmi\test.csv",","

suggestions ?

regards

[sparur]

Hello, Gianni.

What is "table name" ?

You should pass in GetSheetObject() object ID, NOT table name or anything else...

for example:

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff("c:\Programmi\QlikView\Test.xls")

[gbovini · Accepted solution]

Hi Sparur,

thanks, my mistake was just in the syntax.

I checked and now everything is ok.

thanks again, Gianni

[Jayabal1987]

set obj = ActiveDocument.GetSheetObject("table name")

obj.ExportBiff("c:\Programmi\QlikView\Test.xls")

I used this macro to export the table in excel but i couldn't get output its showing error and in obj its showing Nothing