topic Re: Text box export in excel export (very urgent) in QlikView

Text box export in excel export (very urgent)

Wed, 25 Jul 2012 07:02:49 GMT

hi,

I have a situation in macro,i need to export a text box from my report to excel. I am able to export multibox,tables but not text box.

Plz help me with it???

Re: Text box export in excel export (very urgent)

deepakk — Wed, 25 Jul 2012 07:21:47 GMT

Hi,

Try the attach application.

Deepak

Re: Text box export in excel export (very urgent)

RSvebeck — Wed, 25 Jul 2012 07:32:52 GMT

Hi. Just did an example of this. See attached file. //Robert

Re: Text box export in excel export (very urgent)

Wed, 25 Jul 2012 08:19:39 GMT

Hi,

Cud u plz tell me the syntax cz i am using the personal edition of qlikview.

Re: Text box export in excel export (very urgent)

RSvebeck — Wed, 25 Jul 2012 08:32:26 GMT

Hi.

Here is the macros used:

sub ExportExcel()
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = true
Set xlDoc = xlApp.Workbooks.Add()
Set xlSheet = xlDoc.Worksheets.Add
xlSheet.Name = "SheetFromExcel"
xlSheet.Range("A1").Value = getVariable("vButtonText")
xlSheet.Range("A2").Value = getVariable("vTextBoxText")
Set SheetObj = ActiveDocument.GetSheetObject("myChart")
SheetObj.CopyTableToClipboard true
xlSheet.Paste xlSheet.Range("A10")
End sub

function getVariable(varName)
set v = ActiveDocument.Variables(varName)
getVariable = v.GetContent.String
end function

Re: Text box export in excel export (very urgent)

Wed, 25 Jul 2012 08:48:43 GMT

thnx Robert

Re: Text box export in excel export (very urgent)

Wed, 25 Jul 2012 09:25:38 GMT

Hi Robert

There is one more thing,how can the size of the text in the text box be increased when exporting it to the excel??

Re: Text box export in excel export (very urgent)

RSvebeck — Wed, 25 Jul 2012 10:26:51 GMT

Do you mean once the text is in excel?

In that case:

add the line

xlSheet.Columns("A:A").EntireColumn.AutoFit

after the line

xlSheet.Range("A2").Value = getVariable("vTextBoxText")

//Robert

Re: Text box export in excel export (very urgent)

RSvebeck — Wed, 25 Jul 2012 10:32:09 GMT

this is a good list of examples that you may find useful:

http://www.activexperts.com/activmonitor/windowsmanagement/scripts/msoffice/excel/

/Robert