Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Hi,
You can try the attached application, Hope this will solve ur query.
Thanks & Regards
Hi
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
Regards
ASHFAQ
Hi Ashfaq,
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?
Thanks
Hi upendra11,
I have a look to your module. It seems very interesting but when I click on your button nothing is exported to Excel.
I have QV 10 and Excel 2010.
Thanks
Make sure security settings allow system access.
Hi,
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.
Thanks
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.
Yes, I have had a mistake but before I have written Excel 2010.
Thanks
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.
Thanks