Export charts to excel

[Anonymous]

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.

[tamilarasu · Accepted solution]

Check the below link.

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

[Anonymous]

Thanks!

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

[tamilarasu]

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

[Anonymous]

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)

[tamilarasu]

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)

[Anonymous]

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

[tamilarasu]

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.

[tauceef9]

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

[tamilarasu]

Hi Tauceef,

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