Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have some values selected in a List Box. Now I need to export those selected values to a QVD or an Excel File to a particular location (storage path should be predefined and fixed) with the help of a Button.
Could it be done somehow using Macro or something else?
I used Export as action, but the QVD/Excel is not storing in my desired saved path. Sometimes shows message that the created file can't be overwritten.
Please suggest!
Hi All,
Any suggestions please?
My Button need to work fine on Dashboard on Access Point. Users should not see the path to store the QVD/Excel. It should be predefined while creation of button.
Also, is there any way so that, once the Save/Export is complete a Message box should be populated that 'Saving/Exporting Data is Complete'?
Regards!!!
Hi,
adapt this code to your particular case. It is a macro that can be called from your button.:
Sub Export1
ActiveDocument.ClearAll false
pathcorp="F:\"
set corp = ActiveDocument.GetSheetObject("LB01") //Name of your listbox
corp.ExportBiff pathcorp & "TEST.xls"
set XLApp = CreateObject("EXCEL.application")
XLApp.Visible = FALSE
set XLDoc = XLApp.Workbooks.Add
for i=0 to val.Count-1
set MyTable = ActiveDocument.GetSheetObject("LB01")
path="F:\"
MyTable.ExportBiff path & val.Item(i).Text &".xls"
next
Set XLApp = Nothing
Set Table = Nothing
'Msgbox "Exported Sucessfully"
end sub
Hope this helps.
As for the QVD - it can be "exported" only by reload, using "store":
Store <table name> Into QVDName.qvd (qvd);
Hi
Crea la tabla que quieras exportar y selecciona la carpeta destino, genera un botón y en acciones llama la macro.
Si lo pondras en el access point, recuerda que unicamente las macros funcionan con plugin.
----------
Create the table you want to export and select the target folder, creates a button and call the macro in the actions.
If you put in the access point, remember that macros work only with plugin.
sub ExportaQVD
set obj = ActiveDocument.GetSheetObject("CH05")
File = activedocument.Evaluate("QVname.qvd'")
File2 = "C:\Qlikview\" & File
obj.ExportEx File2, 4
end sub
Hi Salto,
Thanks for the help.
Though I don't have experience on Macros, I did tried your script, by changing a bit with my objects. Still I am noticing when I click on the Button created, the Macro script editor opens up, without exporting the selected data.
Could you please post a sample QVW with this implementation?
Regards!
Hi Victor,
Thanks for the help.
Though I don't have experience on Macros, I did tried your script, by changing a bit with my objects. Still I am noticing when I click on the Button created, the Macro script editor opens up, without exporting the selected data.
Could you please post a sample QVW with this implementation?
Regards!
crea una carpeta "Qlikview" en C:.
Cuando lo abras te preguntará por la seguridad por la ejecucion de macros. dale en permitir macros.
Para ver el codigo es con Ctrl + m.
Hi Victor,
Thanks a lot for this.
However noticed one thing.This exact script was not working when I was putting a List box ID. Changed a bit as below:
sub Export
set obj = ActiveDocument.GetSheetObject("LB07")
obj.ServerSideExportEx "C:\QlikView\Export.qvd" , ";" , 4 '0=HTML, 1=Text, 2=Bitmap, 3=XML, 4=QVD, 5=BIFF
end sub
Also, could you please help me in getting a message box populating 'Exported Successfully' once the export is done? It is for users purpose only.
Regards!!