topic Re: Problem to save the exported chart data into excel through macro in QlikView

Problem to save the exported chart data into excel through macro

Anonymous — Fri, 27 Jun 2014 09:21:36 GMT

Hi Geniuses,

I have got one dashboard on web which actually help me to pick the data of different objects and save it into the different sheets of the excel file

Now the problem is its not saving that file, I want that once I reload the dashboard macro will run create the workbook and save it to the specified path and when I run the dashboard again it will replace the excel with the current data that is truncate and load, I dont want concatenation

I am attaching the application please look the macro exportToExcel_Variant2 I want to modify this macro.

Please help me as I have to submit this today

Thanks in advance

Shashank

Re: Problem to save the exported chart data into excel through macro

omyahamburg — Fri, 27 Jun 2014 09:50:15 GMT

Before the "end Sub" command, enter

filePath = "yourDrive:\yourFolder\yourFileName".xlsx"

objExcelWorkbook.SaveAs filePath

Best regards

Joerg

Re: Problem to save the exported chart data into excel through macro

Anonymous — Fri, 27 Jun 2014 09:58:49 GMT

Awsum Its working..... But the problem is that excel will open when macro run I dont want the excel to get opened.... means once it saved the data it should close I dont want to manually close it

Thanks in advance

Re: Problem to save the exported chart data into excel through macro

omyahamburg — Fri, 27 Jun 2014 10:03:33 GMT

then add also

objExcelWorkbook.Close

Re: Problem to save the exported chart data into excel through macro

Anonymous — Fri, 27 Jun 2014 10:11:28 GMT

I have tried that before it's not working, if i add that even the data is not coming into excel. It will show some hanged screen of excel

attach is the screenshot

Re: Problem to save the exported chart data into excel through macro

omyahamburg — Fri, 27 Jun 2014 10:15:30 GMT

Could you attach a sample app ?

Re: Problem to save the exported chart data into excel through macro

Anonymous — Fri, 27 Jun 2014 10:22:32 GMT

I have attached that in the original post..... I dnt know Its not allowing me to attach now..... Please look into that

Thanks

Re: Problem to save the exported chart data into excel through macro

Anonymous — Fri, 27 Jun 2014 10:23:21 GMT

I have attached that in the original post..... I dnt know Its not allowing me to attach now..... Please look into that

Re: Re: Problem to save the exported chart data into excel through macro

Anonymous — Fri, 27 Jun 2014 10:29:21 GMT

Hi,

This app is the one in which I have added your save logic

Please look the macro exportToExcel_Variant2

Re: Problem to save the exported chart data into excel through macro

omyahamburg — Fri, 27 Jun 2014 10:33:11 GMT

Sorry, try to replace with this

filePath ="D:\MacroApp\qlikblog_ExportToMultipleExcelSheets\M"&".xlsx"

Re: Re: Problem to save the exported chart data into excel through macro

Anonymous — Fri, 27 Jun 2014 10:37:19 GMT

Still its not closing same hanged screen problem

Re: Re: Re: Problem to save the exported chart data into excel through macro

omyahamburg — Fri, 27 Jun 2014 10:43:20 GMT

This works with me.

Re: Re: Problem to save the exported chart data into excel through macro

Anonymous — Fri, 27 Jun 2014 10:49:45 GMT

Can You upload it again I think its not properly uploaded as I am not able to open it

Re: Re: Problem to save the exported chart data into excel through macro

omyahamburg — Fri, 27 Jun 2014 11:25:54 GMT

Try to use this in your macro

filePath ="C:\M"&".xlsx" 'try this path first, then change to your path

objExcelWorkbook.SaveAs filePath

objExcelWorkbook.Close

Please note, this closes the Excel file, not Excel itself.

Re: Re: Problem to save the exported chart data into excel through macro

Anonymous — Fri, 27 Jun 2014 11:34:34 GMT

objExcelWorkbook.Application.Quit

I used this and it worked

But realy thanks for ur awsum help