I have a QV document to show more info into several list boxes and some pivot charts. I want to produce an Excel report with the data collected from these objects. The automatic feature Send to Excel for a chart it isn't enough for my purposes because I need to get some data from the list boxes.
Any helps to me to solve this issue, please? Thanks
After making appropriate selections
Right click on the table box or pivot table etc. and then select send to excel.
By this all of your selections for that particular sheet will be send to excel file.
hope that helps
in the list boxes are present the code and not the description of a dimension linked to the fact table. Moreover, in the fact table aren't present all necessary data.
Are you sure about your tip?
inside the module the current local security is set to system access allowed.
Inside the User Preferences, Security tab, are checked the 1st (macro module), the 3rd (run) and the 5th option (configure execution from macro).
When I click on the button, in QV 10 below I can see the message that the macro is executing and then Excel 10 - cartel 1 is opened. Nothing is written on the sheet 1.
Sorry can't help. This is working for me in QV 9 SR4 and Excel 2007.
If by Excel 10 you mean Excel 2010 - you might want to research VB Script in conjunction with this version. I know there are some differences/guidelines.
Ok. I'm able to use successfully the module with QV 10 and Excel 2010. I'm using Excel in Italian language and I have translated the text for "Sheet1" into "Foglio1".
But I'd like to create an unique report on Excel as a data union from more list boxes and charts and not to have a spreadsheet originated as a copy and paste operation.