topic Exporting to excel to shared path in QlikView

Exporting to excel to shared path

lakshmanvepuri — Tue, 29 Sep 2015 06:19:48 GMT

May I know how can we generate excel and save in the Shared path of the drive. for the Qlikview Dashboard

Thanks

L K Vepuri

nagarjuna_kotha — Tue, 29 Sep 2015 06:21:02 GMT

By using Macro code we can do thaT.

lakshmanvepuri — Wed, 30 Sep 2015 01:12:49 GMT

Can I have the sample macro..

nagarjuna_kotha — Wed, 30 Sep 2015 04:15:49 GMT

yah sure.

Try this:

Sub SendToExcel

set obj = ActiveDocument.GetSheetObject("Report7")

x = Now()

x = Replace(x,"/","-")

x = Replace(x,":","-")

FileName="C:\a.xls"

''FileName = "C:\\A" & Rnd & "-" & x & ".xls"

obj.ExportBiff FileName

Set objexcel=GetObject("Excel.Application.")

objExcel.Visible=True

objExcel.Workbooks.Open "C:\a.xls"

End Sub

avinashelite — Wed, 30 Sep 2015 04:45:23 GMT

Try with NPrinting that will the best way to manage this , macro has performance issues

jagan — Mon, 14 Dec 2015 05:49:50 GMT

Hi Lakshman,

Please refer below link for many sample macro scripts

Hope this helps you.

Regards,

jagan.