topic Export charts to excel in QlikView

Export charts to excel

Anonymous — Thu, 25 Feb 2016 09:17:44 GMT

Experts, good day!

I have one test model, which has macro sended charts to ppt.

What changes can i make to make this macro sent charts to excel document? (also i need to deactivate grid in document)

Thanks.

Re: Export charts to excel

tamilarasu — Thu, 25 Feb 2016 09:21:26 GMT

Check the below link.

QlikTip #32: Exporting multiple QV objects to a single Excel document

Re: Export charts to excel

Anonymous — Thu, 25 Feb 2016 09:43:53 GMT

Thanks!

maybe you know how to save result document and send it to outlook mail ?

Re: Export charts to excel

tamilarasu — Thu, 25 Feb 2016 10:07:51 GMT

I just added few lines of code. Now, you can store the file in desired path.

I haven't tried to send the files in outlook. But you can try below link.

How to insert an image in outlook box mail body.

I would like to help you but I don't have outlook in my system.

Note: If you don't want to see the excel window, then change below line to false.

objExcelApp.Visible = True'false if you want to hide Excel

Re: Export charts to excel

Anonymous — Thu, 25 Feb 2016 13:25:23 GMT

Dear, thanks.

i've read post with sending mail by macro.

There's record:

objMail.attachments.add("\\172.16.11.211\Documents\OMS DASHBOARD.jpeg")

Can i use some object name (my opened excel file with charts) instead "\\172.16.11.211\Documents\OMS DASHBOARD.jpeg". ??

In other words, i need to export object to excel file(without saving on computer), link it to some object name and put it to

objMail.attachments.add(ExcelFileObject)

Re: Export charts to excel

tamilarasu — Fri, 26 Feb 2016 02:15:13 GMT

Andrey,

I'm not sure but you can try replace the below lines.

* Add the below line top of the code window. So that other modules can access the variable.

Dim objExcelDoc 'as Excel.Workbook

and replace the line like

objMail.attachments.add(objExcelDoc)

Re: Export charts to excel

Anonymous — Fri, 26 Feb 2016 04:39:00 GMT

click on the chart go to the properties select the copy to clipcard and select the image and paste in the excel

Re: Export charts to excel

tamilarasu — Sat, 27 Feb 2016 16:45:53 GMT

Andre,

You can check the below link. Same kind of thread. I remembered your name when I read this thread.

Macro export asking every time to replace file and showing Outlook message?

Hope this helps you. Let me know.

Re: Export charts to excel

tauceef9 — Tue, 21 Mar 2017 13:12:23 GMT

Hi Nagaraj,

Would you be able to share the code from the above link which is marked a correct answer.

Actually I have Personal Edition and I am not able to open the file at my end and Comments are closed on the blog.

Thanks

Regards,

Tauceef

Re: Export charts to excel

tamilarasu — Wed, 22 Mar 2017 09:24:58 GMT

Hi Tauceef,

Kindly check the attached text file. Have a nice day.

Re: Export charts to excel

tauceef9 — Thu, 23 Mar 2017 06:52:00 GMT

Thanks a lot Nagaraj, you made my day .

Hope now I will be able to achieve what I am trying to do.

Regards,

Tauceef