Export to Excel by Button

[#1]

jagan‌ vinay_bangari‌ ecolomer‌

Hi Experts,

I'm not familiar with macros at all…! Unfortunately, not even the basics..

I need a button that will export a table to excel. Please find the attached qvw file below.

Thank you in advance.

[#2]

Hi all,

I' ve used Gowtham Kesavan Sep 15, 2015 6:38 AM solution for extracting multiple pivots but the extract has merged cells because of the pivots.

Any idea how to unmerge the cells?

thank you

[#3]

Hi Christiana,

you can change the index range excel where starting to print the pivot that you export.

In function exportToExcel_Variant1/2/3 chenge the column 2 of array of object

aryExport(0,2) = "A1"              change to (example)       aryExport(0,2) = "F25"

Regards

Gennaro