Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Leverage your QlikView investment to modernize BI – see how! Join Group
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export Input Box to Excel Workbook

I'm trying to export an input box to excel via macro similar to this method that I know to work with a list box:

sub exportExcel()

  set obj = ActiveDocument.GetSheetObject("LB01")

  obj.ExportBiff "C:\test.xls"

  set obj = nothing

end sub

I know this macro to work successfully and export a list box to an Excel workbook. However, whenever I try to do it with an input box it doesn't execute instead bringing me to the module. To try and make it work wit the input box all I'd do is change the ("LB01") to ("IB01") but to no avail.

I'd like to know what I could to to make it work, what I'm doing wrong, any help is appreciated.