Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Is it possible to export to excel the straight table or pivot table by just right clicking and send it to excel with datetime attached to It.
I have done using the macro but this time i need to just right click and send it to excel with date and time attached.
Thanks the help in advance
Talha
Sure, I do not see a problem. See enclosed. Or did I misunderstood your question?
Hello Rakesh,
I think i have not explained the problem properly. When i export the result of my chart (straight table or pivot table) to the excel i want all the data from the charts and in the end somewhere i want the date and time when this chart gets exported.This is cause the user exports a lot of charts and they want the date and time so that they can track when it got exported.
Thanks for helping me out, if you need more info then let me know, i will try to explain again
Talha
Is it not the name of the file created, something like CH01_20090918_142727.xls? That has the timestamp in the filename.
the only options seem to be adding the date as dimension or using the export selection stamp option, but a unique date would always have to be selected
Sorry Talha, I misunderstood. I don't think you can change anything with the export feature of QV, but you can certainly manipulate your charts to shouw this date/time somewhere somehow. See enclosed one example, where I have used "Total Label" field to populate this information. Now if your charts are using this field for other purpose, you will need to find some other way to show this in the chart somehow. I would be interest in knowing what you ended up doing. So please update here.
Hi Tom Mackay, This is correct.... wow! why didn't I notice that...
Hello Rakesh and Tom,
Yeh I know that when we export we get the date and time but the user is looking for that on the exported data sheet somewhere.I will let you guys know if i come up with some other options.
Thanks for all the time and help
Talha