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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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.