March 10, 2008 at 5:03 am
Hi there,
just wondering is there a way to rename the file to include timestamp when export to excel option is chosen in report viewer...
any help/suggestion is greatly appreciate 🙂 if its possible, any article links/examples.. else is there any workarounds??
Thanks in advance,
Jon 😉
March 11, 2008 at 7:37 am
I don't think so. I did quite a bit of research on timed subscription exporting to excel, because my users LOVE excel. It is also not possible to rename tabs in excel as of yet. I wrote a stored procedure that uses ole automation to open the file, read in the first few cells, and then use that information for file and tab renaming. I'm probably going to use it for custom emailing as well, once I get a chance to finish it.
If you find a workaround, please let me know too!
March 11, 2008 at 9:38 am
Thanks mathew, yup you r right.. did some googling and learn that this issue has been around but there does'nt seem to hv any answer to it either..
anyway thanks for your point 😉
if anyone manage to find a workaround maybe you can post it as a article in this forum that'll be of great help..
cheers, 🙂
jon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply