topic Export with the field name. in QlikView

Export with the field name.

Anonymous — Thu, 22 Jul 2010 19:40:35 GMT

Hello

I created a macro that exports a spreadsheet to excel.
I need the file name. XLS is the field name that is selected in the "select multiple filters.

Can anyone help??

call exportToExcel("CH209", "C:\Temp\FILE NAME.xls")

Export with the field name.

Thu, 22 Jul 2010 19:50:48 GMT

What is Select Multiple Filters? Is that a field?

Your current macro is very hard to read, but here is a snippet of code that should work:

set mySelections = ActiveDocument.Fields("Field").GetSelectedValues
fileName = mySelections.Item(0).text
exportToExcel("CH209", "C:\Temp\" & fileName)

You would want to put in some error checking to verify that one item is selected.

Export with the field name.

Anonymous — Thu, 22 Jul 2010 20:00:47 GMT

FOLLOW COMPLETE MACRO

Sub exportObject1 sub ()
exportToExcel call ("CH209", "C: \ Temp \ FILE Name.xls)
End Sub

sub exportToExcel (objectId, filePath)
dim the
Set o = ActiveDocument.GetSheetObject (objectId)
o.ExportBiff filePath
Set o = nothing
End Sub

topic Export with the field name. in QlikView

Export with the field name.

HelloI created a macro that exports a spreadsheet to excel. I need the file name. XLS is the field name that is selected in the "select multiple filters. Can anyone help??

Export with the field name.

Export with the field name.

FOLLOW COMPLETE MACRO

Hello

I created a macro that exports a spreadsheet to excel.
I need the file name. XLS is the field name that is selected in the "select multiple filters.

Can anyone help??