Exporting to excel to shared path

[lakshmanvepuri]

Hi

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]

By using Macro code we can do thaT.

[lakshmanvepuri]

Can I have the sample macro..

[nagarjuna_kotha]

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]

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

www.vizubi.com/nprinting/quick-start/

[jagan · Accepted solution]

Hi Lakshman,

Please refer below link for many sample macro scripts

Useful Qlikview Macros

Hope this helps you.

Regards,

jagan.