Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the following macro that works great when the object in qlikview is a table:
sub exportHTML
set cs = ActiveDocument.GetSheetObject("CH524")
cs.ServerSideExportEx "C:\test.html" , ";" , 0 '0=HTML, 1=Text, 2=Bitmap, 3=XML, 4=QVD, 5=BIFF
end sub
However, when I try to do the exact same function and the object is a text object,
I receive an error.
Can anyone help me to export a text object to html file?
thanks,
Ella
Hi Elula,
The ServerSideExportEx method does not appear to be available for the text object.
I check the api files from the following post (API in readable format).
Here is a script that will use vbscript to save the text to a file.
sub exportHTML
set cs = ActiveDocument.GetSheetObject("TX01")
msgbox cs.GetText()
Set objFSO=CreateObject("Scripting.FileSystemObject")
' How to write file
outFile="c:\test.html"
Set objFile = objFSO.CreateTextFile(outFile,True)
objFile.Write cs.GetText() & vbCrLf
objFile.Close
end sub
Hope this works for you.
Thanks
Mark
www.techstuffy.com