Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmanvepuri
Creator
Creator

Exporting to excel to shared path

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

1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

Hi Lakshman,

Please refer below link for many sample macro scripts

Useful Qlikview Macros

Hope this helps you.

Regards,

jagan.

View solution in original post

5 Replies
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

By using Macro code we can do thaT.

lakshmanvepuri
Creator
Creator
Author

Can I have the sample macro..

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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
Partner - Champion III
Partner - Champion III

Hi Lakshman,

Please refer below link for many sample macro scripts

Useful Qlikview Macros

Hope this helps you.

Regards,

jagan.