Export ListBox with Macro

Fri, 03 Aug 2012 19:39:03 GMT

Hi all, first sorry for my bad english.

I'm using this macro to export data from a list box:

function ServerExportEx

Set st = ActiveDocument.GetSheetObject("LB35")

st.ServerSideExportEx "C:\FTP\Clientes\"&"MAILS"&".TXT",";",1

end function

The problem is that this macro export all values from list box, and i need only possible values to select, not the excluded values.

Where i need to change the macro?

I hope can understandme and thanks.

Luciano.-

Re: Export ListBox with Macro

IAMDV — Sun, 05 Aug 2012 17:01:42 GMT

Hi Luciano,

Have you considered using...Right click on List Box > Copy to Clipboard > Copy Possible Values and paste them in Excel? You can use this approach without using macros.

However, if you still need macros then you need something like this...

Sub GetPossibleValueFromLB

set LB = ActiveDocument.GetSheetObject("LB01")

boxvalues=LB.GetPossibleValues

for i = lbound(boxvalues) to ubound(boxvalues)

msgbox(boxvalues(i))

next

End Sub

Please integrate the above code with your original code.

Cheers,

topic Re: Export ListBox with Macro in QlikView

Export ListBox with Macro

Re: Export ListBox with Macro