Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am having the following requirement.
when i click on the export button the following st table should be exported to excel with the each region data into one sheet.
per suppose emea region into one sheet, apj into another and ams into one another sheets.
here i am attaching the sample qvw.
below is the data
region | company name | supervisor | sales |
ams | x | sony | 245 |
apj | y | fim | 255 |
emea | z | jen | 265 |
apj | tcs | bin | 450 |
apj | cts | fun | 350 |
ams | bosch | sun | 679 |
emea | lg | ram | 789 |
ams | samsung | rama | 532 |
I am new to macros kindly help me out wit this.
so you want to generate one excel file per country and every excelfile containing the tabs subjid (001-002,....)???
then see attached qvw and adapt the exportpath inside macro according your environment
hope this helps
see attached qvw
hope this helps
Hi Frank,
Thank you for the quick response .
but i need to get the export to excel. this thing i am unable to find in the qvw you shared.
can you help me out
if you press the "createExcelReport" Button within my uploaded qvw, then Excel is opening with the exported Tables, right?
Hi Frank,
when i clicked on export to excel button it is opening the macro script instead of opening in the excel.
make sure that you have these settings activated inside Module and retry:
Hi Frank,
Thank you so much for the help.
i need a small change instead of region 1 and region 2 and region 3 can we get the region names as emea ,ams ,apj as sheet names in the excel
see attached
hope this helps
Hi Frank,
Thanks for all the help you provided.
i need one more help with all the inputs from you i had modified the code below attached .
right now we have hardocded for 2 subjects can you help me to make it dynamic for all the subjid without hardcoding
Your code is simple but here they are using the below code.
Kindly help me out to achieve this.
Thanks and Regards,
Ramya
see attached